Uh, I feel out of context. Can you elaborate a little more?
Did anyone actually take action?
I'm not sure how to, or if I'm supposed to, since I'm based in Canada.
I wonder what would be the advantage of this over a secondary PG instance?
I can think of Lower infra costs to set a service up w/ minimal upfront investment. However, that depends on how far SQLite can be scaled as the DB size grows.
Interesting idea nonetheless!
The fix was just published to the main repository ๐
I see your point. Though the main thing, as I mentioned in the question, is that I'm using features from 4.4 so that strategy wouldn't work for me.
Hopefully they pull it off for real and it will not get bogged down by bureaucracy and red tapes.
That's pretty much what I ended up doing. Install Gnu Make 4.4 as part of the pipeline. I then added a check to warn the user if the Make version they use is not supported.
Nowhere as convenient as using psql but you could try using Python or Perl to have a more civilised interaction w/ SQLite. For Python the module sqlite3 is already in the stdlib and for Perl just install perl-DBD-sqlite using your package manager.
Had no idea such a thing existed!
I'm going to give it a shot and see how it plays along w/ my Gnome desktop (or the other way around actually.)
Interesting. I always thought triggers will turn out to be an expensive overhead and avoided them. Now I know I should have benchmarked my gut feeling ๐
Oh, I see ๐ฏ