jsonis

4 ms·

1. 1.▲
   by jsonis 2y ago

   SV money and banking relationships don't prevent a total meltdown, as seen in the Andreessen Horowitz-backed Synapse saga with Evolve. Assume there's just a 0.1% of a meltdown and you're better off sticking to Vanguard ETFs.
2. 2.▲
   by jsonis 2y ago

   This is exactly what I've tried (and failed at) doing! Can I ask how you handle normalization from vendor data when it contains relationships and multilevel nesting? How do you know when to create a new child table, and which ones to c
3. 3.▲
   by jsonis 2y ago

   Question-- with the yelp api now being paywalled-- and obviously you'd have to write code to handle scraping-- but can you legally scrape yelp to do this? Does the linkedin scraping lawsuit permit scraping yelp?
4. 4.▲
   by jsonis 2y ago

   > Scanning and updating every value because you need to update some subset sucks. Mirrors my experience exactly. Querying json can get complex to get info from the db. SQLite is kind of forgiving because sequences of queries (I mean quer
5. 5.▲
   by jsonis 2y ago

   > These days, my go-to solution is SQLite with two fields (well, three, if you count the implicit ROWID, which is invaluable for paging!): ID and Data, the latter being a JSONB blob. Really!? Are you building applications by chance or so