Reminder that Postgres DDL changes (creating, altering, and deleting tables and other objects) done inside transactions can be rolled back. No such luck in MySQL. It's a big deal; you will care when one of your migrations fails halfway through. https://wiki.postgresql.org/wiki/Transactional_DDL_in_PostgreSQL:_A_Competitive_Analysis …
-
-
Show this threadThanks. Twitter will use this to make your timeline better. UndoUndo
-
-
-
Please help me solve a debate. Is it pronounced post-gress or post-grey?
-
"post-gress" but I think that it is important that we graciously allow other people to pronounce it in an extremely wrong way
-
I don't even know you & I love you for this tweet
-
we have fun
-
I’ve been calling it POST-GRESS-Q-ELL
End of conversation
New conversation -
-
-
I‘m just beginning to switch from MySQL. What do you like especially?
-
It's a million little things. But coming from MySQL, the biggest single thing that comes to mind is that DDL statements can be executed inside a transaction and rolled back if necessary. Makes migrations much less scary.
-
MySQL can't do this?!
- End of conversation
New conversation -
-
-
https://eng.uber.com/mysql-migration/ … Got curious about this thread. Heard of Postgres but not educated on it. Came across this article. Thoughts? Not trying to rain on Postgres, just trying to understand.
-
You and I don't have problems as large as Uber's. Read experience reports from apps of roughly your size if you want to make a decision on what tools to use.
End of conversation
New conversation -
-
-
Yes indeed. One of my favorite lesser-known features is "exclusion constraints" - I don't know of any other db that has those. http://nathanmlong.com/2016/01/protect-your-data-with-postgresql-constraints/ …
- 1 more reply
New conversation -
-
-
It’s the piece of software that I have the most faith in right now. Constant, incremental progress!
-
It's been stellar for two decades now
End of conversation
New conversation -
-
-
#mongodb it’s even better -
Am a recent convert to Mongodb, but via the
@AzureCosmosDB platform -
MongoDB + Python
-
Postresql is great... but in response to
@zurvenia, you haven’t lived until you’ve tried Go + MongoDB. The way structs work with BSON objects. Is pretty great! -
for me there is no way back to relational dbs. at least not for the type of information I manage and I need to access i.e. bioinformatics and medical information
End of conversation
New conversation -
Loading seems to be taking a while.
Twitter may be over capacity or experiencing a momentary hiccup. Try again or visit Twitter Status for more information.