srcreigh

41 ms·

511.
by srcreigh 4y ago
.schema tablename
512.
by srcreigh 4y ago
SQLite added strict mode recently, check it out. Agreed time handling is sub par - could use builtin date formatting from epoch to ISO which would fix all the problems IMO.
513.
by srcreigh 4y ago
Is multi threading necessary for your language/platform? These problems can be avoided using single process async services.
514.
by srcreigh 4y ago
You also run a company which offers kubernetes self hosting as a business, which is quite the bias. Anyways, the question isn't whether client-server databases scale, it's whether SQLite doesn't scale. What were the database
515.
by srcreigh 4y ago
Which obscure Postgres optimization features does SQLite lack? Can you share any extra info about the table layouts or queries which are slower in SQLite vs Postgres? In particular which postgres-specific optimizations have been made?
516.
by srcreigh 4y ago
SQLite has commands to rename columns (this is somewhat new). Which other migration is not supported without new table/copy/drop old table process? Also, MySQL can't run a migration on a FK-constrant table without downtime. T
517.
by srcreigh 4y ago
Nope. SQLite is already available in the same process and using the same file system as your server. In some cases (ex Python) without adding any new dependencies. It's downright silly to try to think of a way to make it easier. Here&#
518.
by srcreigh 4y ago
Such as?
519.
by srcreigh 4y ago
I bet most non-FAANG programmers have indeed never worked on an application which could not be built on a single host with SQLite. And SQLite is in fact more fully featured in some ways than some client-server DBs (when will Postgres add su
520.
by srcreigh 4y ago
https://www.gaia-gis.it/fossil/libspatialite/index
521.
by srcreigh 4y ago
Agree, this is a giant PITA. I think this could be easily fixed. The main sticking point with unix epoch is the SQLite CLI interface, but there could easily (?) be added some kind of mark to columns that it's an epoch timestamp and a c
522.
by srcreigh 4y ago
The question is what kind of "more" is needed. Out of disk space or hitting CPU/mem limits? Splitting off a 2nd service which handles isolated functionality could help, migrating to larger storage could help, migrating some d
523.
by srcreigh 4y ago
How did this situation come to an end? End of life for the service?
524.
by srcreigh 4y ago
Does this practically improve the situation? The odds of two servers breaking at the same time for the same reasons seems very high. I actually can't think of a single example where the secondary sever would keep running. Regression vi
525.
by srcreigh 4y ago
Fair enough, but those things are unrelated to SQLite. Any app which uses a Postgres or MySQL PaaS would need to overcome the same hurdles. It'd be nice if those things were easier, but the SQLite part of it cannot be any simpler or ea
526.
by srcreigh 4y ago
I don’t get this. SQLite can perform 500k writes/s (or 5k write txns/s). What app are you building which requires more than this?
527.
by srcreigh 4y ago
I don’t get this. Go can be compiled to a single binary containing SQLite. Scp the executable and run it. This will work on any Linux vm without any setup…
528.
by srcreigh 4y ago
Also having tons of fun with this Some more feedback: - The blue indicator is 4 ticks behind the playback - It would be nice to have more options for where the sounds can appear, like bars 3 and 4 - When I enable a track, I expect any notes
529.
by srcreigh 4y ago
There’s some sub bass in the kick, don’t miss out by listening on phone speakers
530.
by srcreigh 4y ago
https://peel.fm/5a69bff Really fun to drop the kick & cowbell for a few bars then bring them back in.
531.
by srcreigh 4y ago
That’s the same loop
532.
by srcreigh 4y ago
What type of hiring issue are we talking about?
533.
by srcreigh 4y ago
What join algorithms does this support? How many data sources are integrated so far (what’s the MOM growth?) What’s the largest dataset this integrates with? And how many different people do you estimate have written queries in the language
534.
by srcreigh 4y ago
that’s cool, does this API support index nested loop and hash joins? Or is it just for filtering?
535.
by srcreigh 4y ago
In scheme, (= (+ (/ 2 10) (/ 1 10)) (/ 3 10)) is #t.
536.
by srcreigh 4y ago
A lot of those dropped lines of code is gonna be lines which only contain }.
537.
by srcreigh 4y ago
Grade inflation could be part of this. Look at canadian university admission averages. [1] What percentage of students had 95% or higher grade in high school? Waterloo: 8.1% (2010) vs 38.0% (2020) Western: 4.8% (2010) vs 25.0% (2020) [1]:
538.
by srcreigh 4y ago
It is rejected currently and any dynamic app browser is banned too. No idea how this wasn’t immediately quashed by regulation. It’s a 15 year long version of the M$ antitrust lawsuit. The reason it’s not blocked is probably because Apple br
539.
by srcreigh 4y ago
Yikes, some of this is hitting too close to home. If you can think of any other info to share please write it out. I'm curious about other symptoms, if there's any alternatives to gallbladder removal that you've considered, w
540.
by srcreigh 4y ago
What was the cause for you?

More ›