Hacker Newsnew | past | comments | ask | show | jobs | submitlogin

As a SQL Server developer, a lot of the advice here applies to SQL Server as well (or at least advice that isn't specific to PG tools, such as "Don't use psql -W"). However, the biggest issue with applying these practices to SQL Server is that terms that seem similar may in fact be radically different. For example, the `timestamp` data type in SQL Server isn't at all what you'd think, and `text` is an old deprecated type with poor performance.

So I think there's some good high-level advice here that applies across multiple flavors, but the specifics are really only applicable to PostgreSQL.



Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: