3241
SQL Server 2014 Standard Edition Sucks
The best new features in SQL Server 2014 probably won't come with the cheap prices or licensing. Learn why the release date will probably be an expensive one.
Top posts
Every blog post that took off on Hacker News, ranked by the votes of its best submission. 4,225 posts.
3242
3243
Sorting in Japanese – An Unsolved Problem (2011)
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.
3244
3245
Important database news from the last few months
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.
3246
3247
A Blackstone real estate company exposed SSN digits, DOBs, addresses and more
Update: This post received some attention on Hacker News — see the discussion thread.
3248
3249
3250
3251
Interactive SQLite Documentation: Experiment with Queries in Real-Time
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...
3252
Building a High Performance Data Integration Framework in Go
Behind the scenes of building CloudQuery — architectural decisions, engineering challenges, and lessons learned creating the open-source cloud asset inventory.
3253
Amazon Aurora PostgreSQL Serverless
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…
3254
Lua: A Guide for Redis Users
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.
3255
A LLM+OLAP Solution
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.
3256
3257
Analyzing Spotify Stream History
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…
3258
The time keepers: pg_cron and pg_timetable
Need to schedule tasks in PostgreSQL? Compare pg_cron for simple in-database scheduling with pg_timetable for complex workflows and multi-cluster orchestration.
3259
3260
Why I Wrote Data Science for Crime Analysis with Python (2023)
To help crime analysts get started with python, I am early releasing Data Science for Crime Analysis with Python, an introductory book for analysts.
3261
Super Fuzzy Searching on PostgreSQL
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!
3262
3263
Caching in theory and practice
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.
3264
Why CSV is still king
Build AI-powered data tables
3265
Big Data was used to see if TCM was scientific (2023)
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.”…
3266
3267
The Holes in the Map: England’s Unregistered Land
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 …
3268
SparkFun's migration from MariaDB to PostgreSQL
The devs switch underlying databases for SparkFun.com and somehow, miraculously, the sky stays put firmly up above.
3269
High Frequency Trading Strategies
Discusses performance characteristics of high frequency trading strategies and the requirements for implementation
3270
The ClickHouse Community
Slack is a new way to communicate with your team. It’s faster, better organized, and more secure than email.