At the moment my preference is mongoDB however I am trying to get back up to speed with SQL so I can use PostgreSQL as well.
For further actions, you may consider blocking this person and/or reporting abuse
At the moment my preference is mongoDB however I am trying to get back up to speed with SQL so I can use PostgreSQL as well.
For further actions, you may consider blocking this person and/or reporting abuse
Tom Nijhof -
Sloan the DEV Moderator -
Franck Pachot -
parayan Sharma -
Oldest comments (40)
Switched to PostgreSQL from SQL Server.
I had nothing against SQL Server, other than the fact that it is very windowscentric. PostgreSQL is just as powerful, plus I really like notifications system.
Tell us more about PG notifications? I'd love to see an example of how it works.
It's a basic pub/sub system. The DB sends events to connected clients. You have a channel where a client can be in listening mode on and the DB or other clients can send events to. For example: tapoueh.org/blog/2018/07/postgresq...
To be fair for comparison, SQL Server has service broker, which does the same. It also has became available on Linux recently π
But both are great RDBMSes!
Wow, I haven't worked with SQL Server since Rails came out in 2004.
I have to say, it must have been a cold day in hell when they approved porting SQL Server to Linux. Good for them, though. The irony is that I am now back on Windows 10, running PG inside of a headless WSL2 Ubuntu VM.
PostgreSQL! I used to use MySQL/MariaDB, but PostgreSQL seems to be normal choice for Rails devs, plus I have very few surprises with it.
I used MongoDB recently, while it was fun I realised how much I love having explicit migrations for DB columns.
What do you use to interact with the database do you use a GUI or the CLI? I am currently trying out valentina-db.com/en/ and before that I used pgAdmin.
CLI & TablePlus.
I like the CLI (e.g. the rails console) as it gives me all the stuff my apps does. I normally use TablePlus as a read only view of what's going on.
I still kinda like MySQL :P
PostgreSQL, has been rock solid since the start. (Prior to that used SQL Server primarily (some real weird issues with that one)).
Depends on the type and the size of a project.
For smaller or less complicated projects I'd use MySQL
But for larger or complicated projects I'd use MS SQL Server
Depends on the project :p
PostgreSQL is my standard choice for SQL.
All other options (NoSQL) are depends on project.
Psql
Andrew,
Check out my company's product, HarperDB. It is NoSQL & SQL with a single underlying data model. So you can still execute NoSQL operations while getting up to speed on SQL. If you are interested & it fits your needs / use case you can spin up a free instance: harperdb.io/harperdb-cloud-get-sta...
Cool thanks I will create an account and give it a try.
+1 for mongodb
never going back to sql ;-)
I've done a little bit with Firebase and enjoyed it.
At work I've been using CouchDB because of it's integration with PouchDB.js in our Vue Apps and really enjoy the experience!
I had a terrible experience with Postgress, and in hindsight it was the companies wrapper that ruined anything useful a RDBMS offers.
I'd love to give it's ORDBMS a shot.
SQL Developer was, meh. It's certainly a DBA's favorite, as it requires an actual DBA as the database scales to keep it running well. And the EF drivers aren't as easy to use.
SQL Server has all around been my favorite. It probably always will be, until a relational database isn't required at least.
That depends on the use case. I currently use ClickHouse (clickhouse.tech) to record immutable events.
For user data, settings and other application data I use FaunaDB (fauna.com).
It really depends!
ACID Transactions + clear schema and enforced relationships between schema? PostgresQL or MySQ (probably just postgres haha)
Analytics + Performance for querying business logic? A Columnar Database.
Need to store documents? MongoDB or S3
Need super high performance? Cassandra
Need just key-value store? Use CouchDB or DynamoDB if you got the $$
What do you mean by if you have the money Dynamo? Dynamo is a super well priced database and its pay for what you use. Super super nice stuff.
Good question, while itβs well priced Iβve experienced sudden spikes in price which sucked
Weird dynamo has really stable pricing of course prices will go up with usage so if you randomly spike the database at one point it will spike but other than that you can scale it up and down without having to do anything on your end so you are always paying the lowest price possible.
I'm still a bit sad about RethinkDB.
In any case these days my goto choice is MongoDB and PSQL (depending on the use case)