The allure of SQLite
A couple of times I have wondered why people use SQLite - why use a library and a file when you can easily have a real [RDBMS]?
Perhaps the attraction is the very low barrier of entry to creation, administration and connecting - when you Just-Want-To-Start(tm)¹, these chores of setup are tedious and in the way.
Does that mean that SQLite is the Access of Free Software? ;-)
Maybe SQLite could also prove to be practical when writing tests for modules that depend on database-access? Hm.
¹ And that is usually what you do, when you get an idea and lunge forward in fleshing it out, right? :-)
Add comment
To avoid spam many websites make you fill out a CAPTCHA, or log in via an account at a corporation such as Twitter, Facebook, Google or even Microsoft GitHub.
I have chosen to use a more old school method of spam prevention.
To post a comment here, you need to:
- Configure a newsreader¹ to connect to the server
- Open the newsgroup called
¹ Such as Thunderbird, Pan, slrn, tin or Gnus (part of Emacs).koldfront.dk
on port1119
using nntps (nntp over TLS).lantern.koldfront
and post a follow up to the article.Or, you can fill in this form: