751
The PlanetScale serverless driver for JavaScript
You can now use PlanetScale in HTTP-only environments like Cloudflare Workers, Vercel Edge Functions, and Netlify Edge Functions.
New
The latest blog posts to take off on Hacker News. 2,337 posts.
752
Learn Postgres at the Playground – Postgres compiled to WASM running in browser
Run Postgres in your local web browser with guided tutorials to help you grow your Postgres skills.
753
Faster offset pagination for Rails apps
Introducing FastPage a new gem for ActiveRecord that speeds up deep pagination queries.
754
Why use Paxos instead of Raft?
TLDR: Neon separates storage and compute, substituting the PostgreSQL persistency layer with a custom-made distributed storage written in Rust. Due to this separation, some nodes don’t have persistent disks. The original Raft paper works only with uniform nodes, but Paxos variants support proposers without storage and…
755
Improving Postgres text search speed
CharityAPI.org improved our Postgres response time so that searches initiated via our API were 760% faster without adding an additional tool like Elastic Search. This is how we did it.
756
The four pillars of data observability: metrics, metadata, lineage, and logs
How much data is enough for observability? Learn the key pillars that describe your data and underpin data observability practices in 2024.
757
How SQLite Helps You Do ACID
Let's take a peek at how the rollback journal works.
758
EdgeDB 2.0
Today we're excited to announce the release of EdgeDB 2.0, the latest version of our graph-relational database.
759
760
How Wikipedia influences judicial behavior
Mixed appraisals of one of the Internet’s great friends (or foes), Wikipedia, are reflected in the slightly dystopian article “List of Wikipedia Scandals”, which sits below a Wikipedia web address. Scrutiny aside, billions of users routinely flock to the online, anonymously editable encyclopedia knowledge bank for…
761
SQLite Internals: Pages and B-trees
Let's open a hex editor and see what this thing is made of
762
RStudio Is Becoming Posit
We are very excited to announce that RStudio has a new name, Posit.
763
Shipping Multi-Tenant SaaS Using Postgres Row-Level Security
At Nile, we’re making it easier for companies to build world-class control planes for their infra SaaS products
764
Propagation of mistakes in papers
A blog by and for database architects.
765
766
New method identifies the root causes of statistical outliers
Amazon ICML paper proposes information-theoretic measurement of quantitative causal contribution.
767
Analyzing Indie Hacker Products with Verified Revenue
Indie Hackers is a wonderful community for founders, a vast ocean of shared knowledge and a place to showcase your product journey. A lot of people are sharing their products there along with the revenue, often verified by Stripe. We analyzed the available data to check how much revenue are those products making and…
768
Implementing "seen by" functionality with Postgres
Different approaches for tracking visitor counts with PostgreSQL.
769
PostgreSQL views and materialized views and how they influenced TimescaleDB
Continuous aggregates are one of Timescale's most popular features, but you can’t fully understand them without some context on Postgres views and materialized.
770
30% of Google's Emotions Dataset Is Mislabeled
Last year, Google released their “GoEmotions” dataset: a human-labeled dataset of 58K Reddit comments categorized according to 27 emotions. The problem? A whopping 30% of the dataset is mislabeled! Check out some of the egregious errors, and learn how to build better datasets.30% of Google's Emotions Dataset is…
771
Column order in PostgreSQL does matter
Column order can determine how quickly your data is processed in PostgreSQL. Find out how to troubleshoot performance problems in wide tables
772
Postgres full-text search: A search engine in a database (2021)
With Postgres, you don't need to immediately look farther than your own database management system for a full-text search solution. If you haven't yet given Postgres' built-in full-text search a try, read on for a simple intro.
773
Postgres 15 improves UNIQUE and NULL
Postgres 15 beta 2 was released recently! I enjoy Beta season... reviewing and testing new features is a fun diversion from daily tasks. This post takes a look at an improvement to UNIQUE constraints on columns with NULL values . While the nuances of unique constraints are not as flashy as making sorts faster (that's…
774
I analyzed hospital price lists so you didn't have to
Blog for DoltHub, a website hosting databases made with Dolt, an open-source version-controlled SQL database with Git-like semantics.
775
Scaling our spreadsheet engine from thousands to billions of cells
Causal has joined Lucanet to deliver Extended Planning and Analysis (xP&A) as part of the Lucanet CFO Solution Platform. Make smarter planning decisions with unified real-time insights across financial and operational planning.
776
Historical weather data API for machine learning, free for non-commercial
Get weather data for the past days, weeks or months
777
We are splitting our database into Main and CI
We are splitting our database into Main and CI to improve the scalability and reliability of GitLab.com.
778
De-anonymizing ransomware domains on the dark web
* We have developed three techniques to identify ransomware operators' dark websites hosted on public IP addresses, allowing us to uncover previously unknown infrastructure for the DarkAngels, Snatch, Quantum and Nokoyawa ransomware groups. * The methods we used to identify the public internet IPs involved matching…
779
SQLite or PostgreSQL? It's Complicated
Learn how to benchmark SQLite and PostgreSQL databases.
780
Automated PDF Reports with Python Notebooks
Learn how to build automated PDF reports in Python with Jupyter and Mercury, including scheduling, charts, and email delivery workflows.