search

benbjohnson / postlite

Postgres wire compatible SQLite proxy.
Apache License 2.0
1.21k stars 30 forks source link

Fly.io usage #9

Closed gedw99 closed 2 years ago

gedw99 commented 2 years ago

I get the feeling this is designed to work with fly.io. Could you let us know the intention .

benbjohnson commented 2 years ago

I love what the folks at fly.io are doing but postlite isn't specifically meant for them. The idea came from a Twitter thread with several people including Kurt Mackey at Fly.

https://twitter.com/benbjohnson/status/1508927916561743872

As for intention, developers ask me a lot if they should use SQLite for a project and I tell them what I like about SQLite but I always have two "cons". First, you can't have long-running write transactions. And second, you can't use GUI tools for remote administration. The second one seems to be a big sticking point for people who aren't used to command line tools.

I'd love to just tell folks to use SQLite and only have one "con". :)

gedw99 commented 2 years ago

Ok I see what the intent is now.

Thanks for that @benbjohnson