42 ms·
Because Postgres is mature, works, and has a version number above v1.0?
by yellow_lead 1y ago
Because Postgres is mature, works, and has a version number above v1.0?
- zwnow 1y agoVersion numbers dont mean anything as the whole Elixir ecosystem shows:D
- teeray 1y agoIf v1.0 is your North Star, you should re-evaluate a whole lot of software in your stack: https://0ver.org/#notable-zerover-projects https://0ver.org/#notable-zerover-projects
- 8organicbits 1y agoI think you're focusing on the wrong parts of the comment. People care about things like long-term support. Postgres 13, from 2020, is still officially supported. Litestream 0.1.0 was the first release, also from 2020, but I can't tell if it is supported still. Worrying about the maturity, stability, and support of an application database is very reasonable in risk adverse projects.
- victorbjorklund 1y agoLitestream is just a backup solution. Should probably be compared to a backup solution for postgres that does automated backups over the network etc. That isnt part of postgres. Besides the question wasnt litestream vs postgres backup apps. It was sqlite vs postgres.
- threatofrain 1y agoThe original response at least concerned litestream because the not-1.0 comment only applies to that.
- victorbjorklund 1y agoI'm guessing this is a joke?
- johnfn 1y agoWhy would saying that Postgres is a mature database - more mature than SQLite - be a joke?
- jchanimal 1y agoSQLite is probably more mature than Postgres in terms of service hours.
- hchdifnfbgbf 1y agoI understood the comparison to be with Litestream, not SQLite in general.
- victorbjorklund 1y agoWhy would we compare Litestream (a backup solution) with Postgres (a database)? Would be like comparing Linux with NGINX.
- immibis 1y agoPostgres has a similar replication solution built-in. It's like comparing Samba with Windows Server if your purpose is to run a SMB file server.
- victorbjorklund 1y agoBoth are mature. There are way more sqlite databases running than postgres. The code base is smaller and has less new features added to it every year. What is unstable with sqlite?
- deleted 1y ago[deleted]
- skeeter2020 1y agothis is essentially the "no one ever got fired for buying IBM" statement. One counter is why buy & manage a rack-mounted server when all you need is a raspberry Pi?
- immibis 1y agoPostgres can also run on the Pi. More than once I've started a project with sqlite and then had to migrate to postgres. In my experience it's because of the way sqlite has to lock the whole database file while writing to it, blocking concurrent reads - this isn't a problem in postgres. (There's WAL mode, but it still serialises all writes, and requires periodic explicit checkpointing IME) You may also find you really want a feature postgres has, for example more advanced data types (arrays, JSON), more advanced indices (GIN inverted index on array members), replication...