Hacker News
- Understanding PostgresSQL window functions (2013) https://tapoueh.org/blog/2013/08/understanding-window-functions/ 2 comments
- PostgreSQL Data Types: Date, Timestamp, and Time Zones https://tapoueh.org/blog/2018/04/postgresql-data-types-date-timestamp-and-time-zones/ 7 comments
- Aggregating NBA data, PostgreSQL vs MongoDB http://tapoueh.org/blog/2014/02/17-aggregating-nba-data-PostgreSQL-vs-MongoDB 8 comments
Lobsters
- Why is pgloader so much faster? (2014) https://tapoueh.org/blog/2014/05/why-is-pgloader-so-much-faster/ 5 comments lisp
- PostgreSQL LISTEN/NOTIFY https://tapoueh.org/blog/2018/07/postgresql-listen-notify/ 23 comments databases , programming
- Preventing SQL Injections https://tapoueh.org/blog/2018/11/preventing-sql-injections/ 8 comments databases , security
- Why is pgloader so much faster? https://tapoueh.org/blog/2014/05/why-is-pgloader-so-much-faster/ 3 comments lisp
- Database Modelization Anti-Patterns https://tapoueh.org/blog/2018/03/database-modelization-anti-patterns/ 20 comments programming
- SQL and Business Logic http://tapoueh.org/blog/2017/06/sql-and-business-logic/ 63 comments programming
- There was SQL before window functions and SQL after window functions http://tapoueh.org/blog/2013/08/20-window-functions 6 comments programming
- On loading geolocation data with the new pgLoader that is written in Common Lisp compared to the one written in Python http://tapoueh.org/blog/2013/10/01-loading-geolocation-data.html 3 comments lisp