151
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.
New
The latest blog posts to take off on Hacker News. 300 posts.
152
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.
153
Why Can't Database Tables Index Themselves? (2006)
Here’s a thought question for today: why can’t database tables index themselves? Obviously, indexes are a central concept to databases and database performance. But horror tales still abound of naïve developers who “forget” to index their tables, and encounter massive performance and scalability problems down the road…
154
Historical weather data API for machine learning, free for non-commercial
Get weather data for the past days, weeks or months
155
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.
156
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…
157
SQLite or PostgreSQL? It's Complicated
Learn how to benchmark SQLite and PostgreSQL databases.
158
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.
159
Things to know about databases
How Relational Databases Work. This post talks about how indexes and transactions work on the inside of relational databases.
160
SQLite Release 3.39.0
A complete list of SQLite releases in a single page and a chronology are both also available. A detailed history of every check-in is available at SQLite version control site .
161
162
Revisiting the principles of data-oriented programming
Principles of Data-Oriented Programming. Benefits and costs of Data-Oriented Programming. DOP vs OOP. DOP vs FP.
163
Custom SQL functions for data analytics in PostgreSQL
There is a better way to explore and analyze time-series data with PostgreSQL: hyperfunctions. Learn how to ease your workload with faster and simpler data.
164
Wikimedia Enterprise announces Google and Internet Archive as first customers
Wikimedia Enterprise announced its first customers: multinational technology company Google and nonprofit digital library Internet Archive. Wikimedia Enterprise was recently launched by the Wikimedia Foundation as an opt-in product.
165
One-liner for running queries against CSV files with SQLite
I figured out how to run a SQL query directly against a CSV file using the sqlite3 command-line utility:
166
How we made data aggregation on PostgreSQL better and faster
They’re so fast we can’t catch up! Check out our benchmarks with two datasets to learn how we used continuous aggregates to make queries up to 44,000x faster.
167
How to Find and Stop Running Queries on PostgreSQL
Your PostgreSQL server is seizing up, with some naughty queries consuming too many resources or blocking others. Don’t panic! You can stop those problem queries and stabilize your system.
168
Map Data: False Assumptions
Famously, engineers tend to make wrong assumptions about a lot of things: Names and time are two well-known examples. Maps are a rich source of edge cases. Especially when you start dealing with gl…
169
No, QuestDB is not Faster than ClickHouse
telegra.ph/no-questdb-is-not-faster-than-clickhouse-06-152022144 points63 commentscited by 3Databases & Data details
QuestDB created a minor stir in the small but active world of analytics database benchmarking with this blog article: https://questdb.io/blog/2022/05/26/query-benchmark-questdb-versus-clickhouse-timescale. This is the money quote: “QuestDB is an order of magnitude faster than both TimescaleDB and ClickHouse in this…
170
ReadySet Core: next-generation SQL caching, freely available
Today we’re announcing ReadySet Core, a freely available version of ReadySet that you can run anywhere from your own laptop to any cloud provider, on as many nodes as you need.
171
2022 Cloud Report
The 2022 Cloud Report is the only cloud performance report to compare AWS, Azure, and GCP on benchmarks that reflect critical applications and workloads.
172
How Palo Alto Networks Replaced Kafka with ScyllaDB for Stream Processing
Learn how Palo Alto Networks rearchitected their real time data systems using ScyllaDB’s monstrously fast and scalable NoSQL database.
173
Select ’Hello, World’: Serverless Postgres Built for the Cloud
We have just launched Neon to provide you with the best Postgres experience in the cloud. You can sign up to our waitlist right now and experience serverless Postgres enabled by the separation of storage and compute. The service is still gated by the waitlist as we are onboarding more and more users every day, and we…
174
How to create a dashboard in Python with Jupyter Notebook
Learn how to create a dashboard in Python with Jupyter Notebook, including interactive components and sharing options.
175
Important PostgreSQL 14 update to avoid silent corruption of indexes
Join thousands of people who own a premium domain. Affordable financing available.
176
Hacker News “Who is Hiring?” top-level comments over time
tl;dr: I believe HN Who is Hiring? posts are down; scroll to the bottom for the chart, code lives here. Hacker News. The Orange Site. Since April 2011, it’s had a thread every month, which dares potential employers to answer one question: who is hiring? I take a quick skim through this thread every month. ... Hacker…
177
Cache made consistent: Meta’s cache invalidation solution
Caches help reduce latency, scale read-heavy workloads, and save cost. They are literally everywhere. Caches run on your phone and in your browser. For example, CDNs and DNS are essentially geo-rep…
178
MongoDB Releases Queryable Encryption Preview
Today we are announcing the preview release of Queryable Encryption which allows customers to encrypt sensitive data from the client side, store it as fully randomized encrypted data on the database server side, and run expressive queries on the encrypted data. Learn more.
179
In Defense of OpenStreetMap's Data Model
Who's the customer, anyway?
180
DeWitt Clause, or can you benchmark %database% and get away with it
The DeWitt clause lets database vendors forbid publishing benchmarks. What the clause is, which vendors still use it, and what you can legally publish.