451
My thoughts on Python in Excel
An in-depth review of Microsoft's new Python in Excel functionality
Topics /
Databases & Data
The most popular blog posts about databases & data on Hacker News. 2,337 posts.
452
Babelfish: SQL Server-to-Postgres Translation Layer
“The greatest force in legacy databases is inertia,” a widely regarded industry analyst once told me. Not superior functionality. Not better performance. Not lower cost. None of the above. Just inertia. Developers might say they prefer to run PostgreSQL to proprietary alternatives (and they do), but enterprises have…
453
Sieve is simpler than LRU
SIEVE is Simpler than LRU: an Efficient Turn-Key Eviction Algorithm for Web Caches
454
Prisma 2.0 Beta: Type-safe Database Access
Prisma 2 Beta introduced type-safe database access with Prisma Client, updated docs, and a clearer path toward production readiness.
455
456
Why SQLite is so great for the edge
Everyone already knows that SQLite is great. This article makes the praise much more specific though — it explains why we, the developers of libSQL, think that SQLite is a great choice for bringing your data to the edge.
457
Movable tree CRDTs and Loro's implementation
This article introduces the implementation difficulties and challenges of Movable Tree CRDTs when collaboration, and how Loro implements it and sorts child nodes. The algorithm has high performance and can be used in production.
458
Prisma Postgres – Runs on bare metal and unikernels
At Prisma, we believe that deploying a database should be as simple as adding a new page in Notion. Today, we are excited to share the first milestone towards this vision: Prisma Postgres® gives developers an always-on database with pay-as-you-go pricing, thanks to our unique architecture design.
459
460
461
Comparison – R vs. Python: head to head data analysis
R vs Python — which is better for data analysis and data science? Compare the two languages side by side for an objective answer!
462
Parquet: An efficient, binary file format for table data
Quicker, but also more convenient
463
Google Cloud Firestore NoSQL database is in GA
The Cloud Firestore database is a NoSQL, serverless solution for mobile and web application development -- now generally available globally.
464
Trademark Actions Against the PostgreSQL Community
The PostgreSQL Core Team and the PostgreSQL Community Association of Canada (PGCAC) wish to provide clarification on the ownership and …
465
Exploring PostgreSQL 18's new UUIDv7 support
Exploring what's interesting about UUIDv7 support using a demo crab store.
466
The MongoDB hack and the importance of secure defaults
There’s a widespread attack on insecure MongoDB installs that has resulted in over 28,000 databases being held ransom. This post explains the hack, how to protect yourself and what can we learn from it.
467
468
GraphRAG is now on GitHub
GraphRAG, a graph-based approach to retrieval-augmented generation (RAG) that significantly improves question-answering over private or previously unseen datasets, is now available on GitHub. Learn more:
469
PostgreSQL 11.3 and 10.8
The PostgreSQL Global Development Group has released an update to all supported versions of our database system, including 11.3, 10.8, …
470
Asynchronous I/O in DuckDB: Work, Thread, Work
Starting with v2.0, scheduled for fall 2026, DuckDB will support asynchronous reads of Parquet and CSV files. This can significantly speed up queries when synchronous I/O does not saturate the available bandwidth, as is typical in EC2/S3 compute-storage setups.
471
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…
472
The drive stats of Backblaze storage pods
Dive into Backblaze's analysis of storage server performance, exploring Drive Stats, Storage Pods, and insights on drive failure rates since 2009.
473
Neki – Sharded Postgres
Neki, sharded Postgres by PlanetScale, is now available in platform preview.
474
Will Amazon S3 Vectors kill vector databases or save them?
AWS S3 Vectors aims for 90% cost savings for vector storage. But will it kill vectordbs like Milvus? A deep dive into costs, limits, and the future of tiered storage.
475
Amazon Location Service
Update June 1, 2021 – Amazon Location Service is now generally available and includes routing and raster (satellite) maps. You can easily and securely add maps, geocoding, routing, tracking, and geofencing to your applications. Read more about the new features in our new blog post here or try it now in the console. We…
476
One Billion Drive Hours and Counting: Q1 2016 Hard Drive Stats
61,590 hard drives were used in our data center during Q1, 2016. We take a deep dive into the usage to see what we can learn about their performance.
477
PlanetScale – Database for Developers
PlanetScale is the first database designed for developer workflows on top of the technology of the hyperscalers.
478
Announcing R Tools for Visual Studio
Access to this page requires authorization. You can try signing in or changing directories .
479
Hedge funds use satellite images to beat Wall Street
Berkeley Haas research finds there may be a dark side to the rise of “alternative data” in capital markets While Assoc. Prof. Panos Patatoukas was discussing Walmart in his Financial Information Analysis course last year, a student brought up the story of how company founder Sam Walton used to count cars in store…
480
Excel now supports multiple values in a single cell
Throughout Excel's 40-year history, you've only been able to put one value per cell. In this announcement, we're excited to share how that's changing with...