Hacker News new | ask | show | jobs
by olefoo 3823 days ago
Install it, and then build something.

A few things you will want to look at that are different:

1. data types are much richer and more useful than in mysql

2. transactional DDL means migrations are atomic.

3. schemas are what mysql refers to as databases. Remember to set `search_path`.

4. roles and grants are somewhat more expressive and work differently than in mysql, but not that differently for the simpler use cases

5. database functions ( aka stored procedures ) are awesome as are extension languages.

1 comments

On point 5... love PLv8, which imho makes working with the newer JSON data types really nice.