Learning SQL and building a DB, and I'm primarily interested in searching text, am I better off with SQLite or Postgresql? The app will be entirely local so my first thought was SQLite, however Postgres seems to have better support for different search mechanisms (like trigram): https://news.ycombinator.com/item?id=27179479
@zyd Postgres is definitely more powerful, but it comes with all the overhead of a permanent database server process, TCP/IP access, configuring cleanup, and so on. There are lots of jobs SQLite can't do, but when I'm writing something it can, that's what I tend to use.
Yeah I got hit over the head the other day with that one trying to connect to a postgresql db from my Lisp REPL. Turns out no one uses the ident method of authentication but it is the default in the postgresql config on Fedora (pg_hba.conf), so had to change that to use md5.
Add comment