The latest blog posts to take off on Hacker News. 4,224 posts.
“JPEG” or the image encoding specification by the “Joint Photographic Experts Group” (JPEG) is a truly universal format at this stage. You really cannot go very far on the internet without seeing a JPEG file. The amount of content encoded in JPEGs must be surely biblical by now. If there is one thing that is going to…
Explore the changes and reasons behind OpenZFS 2.0. This article clarifies the transition from feature flags and its impact on FreeBSD 13.
PlanetScale is now GA.
Analyze the claims made by Snowflake regarding price/performance compared to Databricks and the counterarguments presented.
Build a redis server in Elixir
Many people see a homelessness crisis, but what does the data say? We examine different locations, rates of change, types of homelessness, and mental health and substance abuse issues.
Features you already have but may not know about!
Haiying Tang takes you on a tour of LZ$ TOAST, the new column opton compression in PostgreSQL 14, and shows the speed and compression ratio gains.
So I made a mildly controversial tweet. Lots of people enjoyed it, but the LinkedIn-adjacent section of data science Twitter is not happy about it. I want to provide as much context for it as I can…
At Superwall we’re building an SDK to help App Developers increase their revenue by showing the right offer to the right person at the right time. Follow me on twitter for little tips and articles like this one.
We take a behind the scenes look at the pganalyze Index Advisor and discuss a few recent improvements, such as utilizing selectivity information better.
An example of how you can encrypt Postgres data at rest using PGO, the open source Postgres Operator from Crunchy Data using AWS EBS gp2 volumes.
The papers over the next few weeks will be from (or related to) research from VLDB 2021 - on the horizon is one of my favorite systems conferences SOSP . As always, feel free to reach out on Twitter with feedback or suggestions about papers to read! These paper reviews can be delivered weekly to your inbox , or you…
DuckDB-Wasm is an in-process analytical SQL database for the browser. It is powered by WebAssembly, speaks Arrow fluently, reads Parquet, CSV, and JSON files backed by Filesystem APIs or HTTP requests, and has been tested with Chrome, Firefox, Safari, and Node.js. You can try it at shell.duckdb.org or on Observable.
Babelfish for PostgreSQL is an Apache-2.0 and PostgreSQL open source project that adds a Microsoft SQL Server-compatible end-point to PostgreSQL to enable your PostgreSQL database to understand the SQL Server wire protocol and commonly used SQL Server commands.
This is not a competition, is just to show how to use the hardware with relative efficiency, being the idea is to show something collaborative rather than competitive.
Learn how you can leverage Python and Pandas from directly inside PostgreSQL to build your own recommendation engine.
A site around enabling companies and knowledge workers to be informed and enabled with the data they need for their work.
Find out which jobs most often pair together among married couples.
Learn how audit tables helped us avoid a serious incident, and how you can create audit tables in your own Postgres databases.
CockroachDB serverless is the first truly scalable serverless SQL database. Learn how it works and how a serverless sql database can relieve the operational burden of developers.
Welcome to acronym city! The Court of Appeal of Brussels has made an interesting ruling. A customer complained that their bank was spelling the customer's name incorrectly. The bank didn't have support for diacritical marks. Things like á, è, ô, ü, ç etc. Those accents are common in many languages. So it was a little…
The humble favicon was messily birthed with the pernicious IE5 release. Since that fateful day, browsers have slowly expanded favicon technology to encompass many wildly differing and lightly documented use cases. Here in 2021 favicons are found primarily in browser tabs, home screens, and Google search results, but…
We provide around-the-clock threat detection and incident response, backed by expert consulting to keep your organization secure.
Function pipelines allow you to analyze data by composing multiple functions in SQL and express complex logic in PostgreSQL in a cleaner way.
