2

I'm looking for a program that's specifically not an SQL server. SQL servers seem to deal with permissions, connectivity, and all that jazz.

I just want a command line program that I can give an SQL command or script file, a database file, and have it alter/query the file according to the commands issued. Nothing more, nothing less.

Here's an example of my use case

$ ls
database
$ sql-thing --command "SELECT MIN(Balance) FROM Users"
...
5

Sounds like Sqlite would be just the thing. Sqlite comes as a C library and command-line utility that executes SQL statements against a database file. The software intelligently cootdinates multiple connections to one file, but doesn't use a client-server architecture.

2
  • Worth pointing out it's available cross-platform. And though being very light-weight, can deal with quite some data. For example, a small Nextcloud instance ;)
    – Izzy
    Sep 30 '20 at 17:16
  • Didn't know SQLite offers a CLI, thought it was just a library. Thanks! :) Oct 11 '20 at 20:04

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.