Topics /
The most popular blog posts about databases & data on Hacker News. 4,224 posts.
Sorting Japanese is not only difficult—it’s an unsolved problem. This seems hard to believe if you are not familiar with the complexities of processing Japanese digitally. But what is trivially easy in English is impossible in Japanese, even with the amount of computer power we have available today.
Google and Amazon acknowledge benefits of SQL, Elasticsearch introduces SQL interface, and MySQL finally becomes modern…after 20 years. These are exciting times in the world of databases.
Update: This post received some attention on Hacker News — see the discussion thread.
At SQLite Cloud, we are dedicated to making database management as seamless and intuitive as possible. Today, we are thrilled to unveil a groundbreaking addition to our platform - the Interactive SQLite Documentation! Now, alongside our comprehensive...
Behind the scenes of building CloudQuery — architectural decisions, engineering challenges, and lessons learned creating the open-source cloud asset inventory.
The database is usually the most critical part of a software architecture and managing databases, especially relational ones, has never been easy. For this reason, we created Amazon Aurora Serverless, an auto-scaling version of Amazon Aurora that automatically starts up, shuts down and scales up or down based on your…
You’ve heard that Redis has an embedded scripting language, but haven’t given it a try yet? Here’s a tour of what you need to understand to use the power of Lua with your Redis server.
The exploration of a LLM+OLAP solution is a bumpy journey, but phew, it now works well for the Tencent case, and they're writing down every lesson learned to share with you.
I recently learned Spotify provides downloads for users’ streaming history. For me, this is over 10 years worth of data, so at the very least it seemed like a good nostalgia trip. This post covers some of my analysis of my personal export, and hopefully is a good starting place if you’re interested in exploring your…
Need to schedule tasks in PostgreSQL? Compare pg_cron for simple in-database scheduling with pg_timetable for complex workflows and multi-cluster orchestration.
To help crime analysts get started with python, I am early releasing Data Science for Crime Analysis with Python, an introductory book for analysts.
Bartlett Publishing has put together several lists of books available from many various publishers which are essential reading for anyone interested in the topic. Check them out today!
Dash knows your context, your team, and your work, so your team can stay organized, easily find and share knowledge, and keep projects secure, all from one place.
People love to show that skeptics were wrong about something, especially when national pride hangs in the balance. The South China Morning Post published the following headline on November 3rd: “Scientists find traditional Chinese medicine is based on a complex network of proteins – 3,000 years before modern science.”…
Coding and writing by Anna Powell-Smith. Around 15% of the freehold land in England & Wales is unregistered. What this means is that if you go to the Land Registry and ask them ‘Who owns …
The devs switch underlying databases for SparkFun.com and somehow, miraculously, the sky stays put firmly up above.
Discusses performance characteristics of high frequency trading strategies and the requirements for implementation
Slack is a new way to communicate with your team. It’s faster, better organized, and more secure than email.
A streaming SQL engine keeps queries’ results up to date without ever having to recalculate them, even as the underlying data changes. To explain this, imagine a simple query, such as SELECT count(*) FROM humans
