Suggestion: SQLite backend

owenthereal / jqplay

A playground for jq, written in Go

https://jqplay.org

MIT License

728 stars 89 forks source link

Suggestion: SQLite backend #87

Open sammcj opened 5 years ago

sammcj commented 5 years ago

Looking at this neat little project I was a bit surprised that it needed a full (OR)DBMS.

I love PostgreSQL, but sometimes for small, self-contained projects I think that SQLite is (perhaps) a wise choice - especially when it's going to often be run in Docker containers for local use as it saves having to pull down a full PostgreSQL Docker image and run a container for it.

If it's not worth the effort feel free to reject the suggestion :)

davidfetter commented 4 years ago

With utmost respect, this isn't the era when a few megabytes' worth of infrastructure is even noticeable. Is it really all that burdensome to be running PostgreSQL?

sammcj commented 4 years ago

I understand what you’re saying, but I don’t think that to run a simple app you should have to install, configure and maintain a full database server.

It’s not about the cost of running it - it’s about the practicality. For example if you want to run this ad-how on your laptop when you need it - it’s a pain to have to install and run a database server.