Getting Used to Postgres from MySQL - I Choose You, Postico
source link: https://fuzzyblog.io/blog/postgres/2020/01/20/getting-used-to-postgres-from-mysql-i-choose-you-postico.html
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
Getting Used to Postgres from MySQL - I Choose You, Postico
Jan 20, 2020
Despite my mildly fanatical adherence to MySQL, there really is nothing wrong with Postgres and quite a bit to like. Given that Postgres is the default database for Heroku, I am spending more and more time using Postgres these days. What I've found is that my resistance to Postgres, more than anything else, was simply that I was really, really used to the MySQL command line and shell.
What I've found is that if you pair Postico with Postgres then it makes a very easy transition from MySQL. Postico is a wonderfully written app (yes I'm a paid user now) that provides a great DB viewing and manipulation tool right down to row level editing. I found myself today, rather than writing a web form to update the database simply editing the data with Postico. Given how easily I generate CRUD apps, that's a pretty big step for me.
Recommended.
Recommend
About Joyk
Aggregate valuable and interesting links.
Joyk means Joy of geeK