SQLite: The Lightweight Database With Heavy Trust Issues

Ah, the classic baby shape sorter toy, but make it database . When your data architecture strategy is literally "if it fits, it ships." Junior devs looking at their PostgreSQL database like it's some magical black hole where any data structure can and should go. Who needs schema validation when you have determination and a hammer? PostgreSQL: Technically versatile enough to store your hopes, dreams, and that JSON blob you were too lazy to normalize.

Content Me every time I need to use a regex so I copy it from a conveniently specific StackOverflow post like your funny words magic man

The eternal dance of users forgetting passwords and sysadmins shrugging helplessly! Proper password storage means even admins can't see your actual password - they can only nuke it back to factory settings. That's not incompetence; that's security by design . Your password should be a one-way hash buried so deep that even the database admin is just staring at a cryptographic salad. If your IT person CAN tell you your password, update your resume immediately because that company's security is more vulnerable than PHP without input sanitization.

Content JUSTUSE RAW SOL NOIYOU NEED TO USE AN ORM, GREATE A LOT OF COMPLEXITY, USE A WEIRD QUERY BUILDER, CREATE INEFFICIENT QUERIES AND IN THE 149END, USE RAW SOL ON IT 14 AUSTUSE RAW SOL 0.1 10 score 55 2 2 0.1 70 85 100 115 130 145

Content Is Your Child Texting About Programming Languages? What your C obsessed teen's texts actually mean omg - one more generic wtf -wheres the function fml - for my loop idfc - indentation doesn't feel correct lol - logic on loop aka - abhorrent kafkaesque arithmetic rofl - right-oriented frame layout imo - iteration may overload stfu - statically typed feels unwise brb - bad recursion brb

Content Alex Garrett-Smith alexjgarrett I built a browser extension that prevents copying from Stack Overflow posts. C stackoverflow Products PUBLIC Questions Tags 21 stackoverflow.comquestions8578385postgresql-create-view Q search.. d Stack Overtlow No Copy Log in Sian ur This one should do the job: create or replace view xxx as select staffid, datetrunc('day', tr min(transactiontime max(transactiontime transactiondate, ition, Clone counties from usertransactions group by staffid, datetrunc( 'day', transactiontime); Companie COLLECTIVES Explore Collectives Share Imorove this answer Follov. edited Dec 20, 2011 at 17:08 answered Dec 20, 2011 at 16:18 GO.GK 0 14 035 0 115 Join Stack Overflow to find the best answer to your technical question, help others answer theirs Sign up G Sign up with Google Sian up with GitHub If Sign up with Facebook 0:08 395 views rio