The latest Postgres news, articles, tools, and projects.
Hi, you may notice a bit of a change with our design this week. We want to provide a richer experience as the year goes on, so we've got a more flexible layout - keep an eye out for some new features we're running soon. If you have anything you want to tell us or submit for future inclusion, hit reply and send us an email :-) — The Postgres Weekly Team | JackDB: A Modern Database Client — JackDB is a web-based database client with built-in tools for security and collaboration. Sign up for a free trial today. JackDB, Inc. sponsor | A Postgres Row Level Security Primer — Row Level Security (RLS) allows an administrator to define if a user should be able to view or manipulate specific rows of data in a table. Jonathan S. Katz | A particularly complex 'bump chart' | PostgreSQL Maximum Table Sizes — The effective limit used to be 32 terabytes, became 2 exabytes in Postgres 10, and will be 131 yottabytes in Postgres 11 due to the resolution of an interesting bug. Simon Riggs | The 'null' Pitfall in SQL — Using != in a WHERE clause won't match nulls - you'd need IS DISTINCT FROM for that. Tanin Na Nakorn | Advanced SQL: Common Table Expressions — The latest in a series discussing advanced SQL concepts in the context of how they improve more elementary SQL. This time, temporary in-query tables in the form of common table expressions (CTE). Michal Konarski | An example of a Common Table Expression (CTE) in an SQL query | |
No comments:
Post a Comment