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
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 ;-)