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"
...
Improve this question

1 Answer 1

Reset to default
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.

Improve this answer
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, 2020 at 17:16
  • Didn't know SQLite offers a CLI, thought it was just a library. Thanks! :)
    – schuelermine
    Oct 11, 2020 at 20:04

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

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