5 ms·
I still use MySQL because trying out PostgreSQL recently scared me away. Maybe I was trying the wrong thing but I couldn't get pgAdmin to display my tables. I t
by ancarda 13y ago
I still use MySQL because trying out PostgreSQL recently scared me away. Maybe I was trying the wrong thing but I couldn't get pgAdmin to display my tables. I think I sank most of my afternoon trying unsuccessfully to do something MySQL can do in 5 minutes.
I recognize I'm used to MySQL but I was under the impression that because PostgreSQL has a similar syntax (SQL) it wouldn't take too long to pickup.
- jherdman 13y agoCan you elaborate further?
- ancarda 13y agoComing from a MySQL background, I sort-of assumed PostgreSQL worked the same way. I remember after setting up the server, pgAdmin was very difficult to navigate. I managed to get a database and table made and got some data in (using SQL) but I couldn't view any of the data. Compared to MySQL + Sequel Pro it was very difficult to use for a beginner. Postgres is very powerful and can do a lot. I think I just need a good tutorial and some time to get used to it.
- Sssnake 13y agoNone of that has anything to do with postgresql. Pgadmin is crappy, don't use it. Use one of the dozens of database independent admin tools, or just stick with the best tool: psql.
- mixmastamyk 13y agoUnfortunately things that take 5 minutes in a complex application typically required an order of magnitude larger investment up front in manual reading and experience.
- gtaylor 13y agoI deal with Postgres a good bit, but will be the first to tell you that pgAdmin has got some issues. It's a very clunky, buggy, moody piece of software. I've had better luck learning how to use the psql command/shell than mess with pgAdmin, at least in certain cases. To take your example of displaying tables, psql in and type: \dt The rest is just a search away.
- KingMob 13y agoI have idle daydreams where Sequel Pro is finally ported to Postgres. pgAdmin is horrendous.
- ancarda 13y agoThat would be amazing. Sequel Pro makes MySQL management so easy. Have you emailed the author asking for that feature? Edit: It seems they are working on it but I i'm not sure when we can expect a release: http://stuconnolly.com/blog/sequel-pro-postgresql-support/ http://stuconnolly.com/blog/sequel-pro-postgresql-support/
- johne20 13y agoI have always stated postgres would become much more widely adopted if it was released on RDS and.... they finish the sequel pro support. Half way there ;)