Post ALWPLiZt7CVVUOIe80 by shoeberto@straylight.expectnomore.net
 (DIR) More posts by shoeberto@straylight.expectnomore.net
 (DIR) Post #ALWMQKa3SqSqeFsz3I by juliobiason@functional.cafe
       2022-07-15T13:14:18Z
       
       0 likes, 0 repeats
       
       Person: "How can I use SQLite to have a question and four answers, but later I want to have, say, 7."Me: Explains database normalization, how to use two tables, have unlimited storage.Person: "What if I have a single field and add all the answers with : between them?"Me: 🤦‍♂️
       
 (DIR) Post #ALWMQPrxnglD3FIrA0 by shoeberto@straylight.expectnomore.net
       2022-07-15T13:48:24Z
       
       0 likes, 0 repeats
       
       @juliobiason what's wrong with that answer, sounds web-scale to me
       
 (DIR) Post #ALWMQRUHmh0c4OEyX2 by shoeberto@straylight.expectnomore.net
       2022-07-15T13:48:35Z
       
       0 likes, 0 repeats
       
       @juliobiason (I'm joking)
       
 (DIR) Post #ALWMQVbWTjAspzeoMq by juliobiason@functional.cafe
       2022-07-15T13:49:16Z
       
       0 likes, 0 repeats
       
       @shoeberto No, you see. SQLite is not webscale. Only Mongo is webscale.https://www.youtube.com/watch?v=b2F-DItXtZs
       
 (DIR) Post #ALWMQVyv4jtE0YbUps by shoeberto@straylight.expectnomore.net
       2022-07-15T13:53:23Z
       
       0 likes, 0 repeats
       
       @juliobiason bro....... just store json in sqlite, best of both worldsAnd then use a JSON schema like{ "answer": "answer1:answer2:answer3:answer4"}problem solved, ship it!!!
       
 (DIR) Post #ALWOeHRG8sTIrmYEIS by juliobiason@functional.cafe
       2022-07-15T13:54:37Z
       
       0 likes, 0 repeats
       
       @shoeberto Me: "Oh, you know storing JSON would be actually better than using : as a separator. It kinda makes sense..."Me: See JSON.Me: :blobcatscared:​
       
 (DIR) Post #ALWOeIlrBmXezxCC2a by juliobiason@functional.cafe
       2022-07-15T13:54:46Z
       
       0 likes, 0 repeats
       
       @shoeberto True story.
       
 (DIR) Post #ALWOeOW7pBWUotsiLw by veer66@mstdn.io
       2022-07-15T16:40:55Z
       
       0 likes, 0 repeats
       
       @juliobiason @shoeberto I have never done this. I always use a vertical bar as a separator. 🤔
       
 (DIR) Post #ALWPLiZt7CVVUOIe80 by shoeberto@straylight.expectnomore.net
       2022-07-15T16:46:16Z
       
       0 likes, 0 repeats
       
       @veer66 @juliobiason Ahh, finally, a real DBA on the fediverse, someone who can appreciate JSON-encoded CSVs (still stored in SQLite)