Ask HN: Any decent postgreSQL tutorial for a newbie | Hacker News Reader

Ask HN: Any decent postgreSQL tutorial for a newbie

18 pointscodecrusade11 comments

Its been extremely depressing and frustrating. Can anyone help please?

I go into configuring postgres for my automation book. You can also check out the source code to see how my script set ups postgres.

http://www.amazon.com/Deploy-Rails-BlueBook-2014-Edition-ebo...

https://github.com/jbwyatt4/railsbluebook2014/blob/master/co...

Just remember to login as the postgres user in Linux.

For SQL in general SQLZoo is a horrible looking website, but if you go through the tracks you will actually learn a bit.

If you're having issues with using postgresql with Rails and heroku (judging from post below), then you're really asking how use those three things together. In this case there are plenty of examples of all the things that can go wrong and how to fix them on stack overflow. If you'd like to send me the errors you're getting and other details of why it's breaking I'd be glad to field a couple emails (contact in profile).

Newbie in what sense?

Are you an experienced database administrator looking at postgreSQL for a new project?

Are you an experienced programmer, coming to postgreSQL as an option for your first project with three tiered architecture?

Are you new to programming and want to learn to database?

Are you new to databases and expect them to be pretty much like word processors and spreadsheets?

Around Point 2 and 3.I have an app that I built on Mysql and now trying to host on Heroku- therefore the confusion.

Why Heroku rather than scaling the MySQL?

Here's one http://www.postgresqltutorial.com/

Thanks- I just booked you a seat in heaven-god bless

http://use-the-index-luke.com/ helps when you deal with performance issues. The examples can be altered for your particular SQL server including postgres.

There are plenty of tutorials for SQL in general those should work fine for PostgreSQL too. What seems to be the problem?

there's a large body of postgresql-specific knowledge. Don't be that guy.

there's a large body of postgresql-specific knowledge. Don't be that guy.

Yes... and the OP was very unspecific as to what exactly was the problem. Maybe he/she just doesn't get SQL, I don't know. If the question was PostgreSQL specific, then that is another issue.

Reply on news.ycombinator.com