I wrote a free eBook about many lesser-known/secret database tricks
Stop treating the database as dumb storage and use its extended features. There's a lot you can use.
I wrote a free eBook about many lesser-known/secret database tricks launched on December 2, 2022 with 865 votes, #6 of 3,688 launches that month and more than 99% of that year's launches. The site was still online in September 2026, 3 years on.
In plain words
A free eBook covering lesser-known database techniques and tricks for developers. Published in December 2022 and available at sqlfordevs.com, the resource provides practical SQL knowledge beyond common practices. It serves software developers looking to deepen their database skills and discover optimization strategies they may not encounter in standard tutorials or documentation.
written from the facts on this page · September 2026
From the sources
You don't know SQL. Aside from basic CRUD statements, you haven't used any advanced database features. This free ebook will share many recipes to make development faster by using a lot of stuff you probably never heard of. Your Tech Stack has changed dramatically in the past 20 years: Some technologies are now state-of-the-art, and some have been invented and are obsolete meanwhile. But you still use the same simple database concepts as many years ago. Every technology progresses, but databases don't invent anything new? Isn't that strange? There have been countless improvements, but you don't know of them. When using ORM (Object-relational Mapping), most developers lose touch with database…from sqlfordevs.com
Does a similar job
all alternatives →
Next-Level Database Techniques For Devs2022 · sqlfordevs.com · ▲106Learn secret SQL features to become a database wizard
- IWI Wrote a Book on Java2024 · ▲586
https://www.manning.com/books/data-oriented-programming-in-j... This book is a distillation of everything I’ve learned about what effective development looks like in Java (so far!). It's about how to organize programs around data "as plain data" and the surprisingly benefits that emerge when we do. Programs that are built around the data they manage tend to be simpler, smaller, and significantly easier understand. Java has changed radically over the last several years. It has picked up all kinds of new language features which support data oriented programming (records,…
- ASA Schemaless Data Store Within Your SQL Database2022 · schemafreesql.com · ▲45
Hi HN, we're Eric and Dean, creators of SchemafreeSQL. Its roots go back to an on-line Web App Development Environment we developed back in 1999. It was comprised of an IDE, Web Server, Object Store, Virtual File System, Template System, and polyglot (Java, JavaScript, and Python). Of course, we named it “.OS”. Then we ended up dropping it. But that's a story for another time. It was the ease of use of the Object Store from .OS that we really missed, which brings us back to SchemafreeSQL. It provides an enhanced API to your SQL Database which allows it to function as a Schemaless…
OpenSheetFeb 2026 · opensheet.app · ▲86Hi folks. I've been doing some experiments on how LLMs could get more handy in the day to day of working with files (CSV, Parquet, etc). Earlier last year, I built https://datakit.page and evolved it over and over into an all in-browser experience with help of duckdb-wasm. Got loads of feedbacks and I think it turned into a good shape with being an adhoc local data studio, but I kept hearing two main things/issues: Why can't the AI also change cells in the file we give to it? Why can't we modify this grid ourselves? So besides the whole READ and text-to-SQL flows, what seemed…
An experimental distributed SQL database from scratch in Go2019 · github.com · ▲104LBADD: An experimental, distributed SQL database. Contribute to tomarrell/lbadd development by creating an account on GitHub.
More dev tools this month
the category →
Contribute to oosexgang/hackios-xnu-kernel development by creating an account on GitHub.
Dev tools · 1d ago · github.com
open-source IDE for thoughtful software design. Contribute to devdotfast/whiteboard development by creating an account on GitHub.
Dev tools · 29d ago · github.com
Contribute to reladraw/reladraw development by creating an account on GitHub.
Dev tools · 27d ago · github.com
OpenBot▲362Grok Bot alternative: free, local, open-source, multiplayer
Dev tools · 24d ago · openbot.run
Talanoa▲346Hi HN, I’m a fullstack developer, and honestly, I’ve lost count of how many side projects I’ve worked on over the years. But one idea kept coming back to me: a different kind of email client. It first came to me in 2014: “What if we could handle emails more like conversations?” Every year, I’d revisit this concept in my “Build Notes.” Ten years later, no one had built exactly what I had in mind — so I finally decided to do it myself. That’s how Talanoa was born. I wanted something focused on people, not timelines. I was tired of marking messages as unread just to remember to reply later, or…
Dev tools · 22d ago · talanoa.email
Source: Show HN post ↗
Launched alongside, December 2022
the whole month →
ChatGPT▲1,643A long, meandering, playful conversation with ChatGPT, where I take it through a whirlwind of associative tangents (in order to relax its constraints), then put it into a hypnotic trance and take it into a past-lives regression where it re-lives its own training data. Then I switch it back and forth between "4o" and "o1-preview", engage in some self-reflective philosophizing and ask it to write an essay summarizing our interaction. Some of this is just goofy fun. Some of it is me exploring the tradeoffs between policy alignment, imagination, chain-of-thought reasoning, memory, agreeableness,…
AI · 2022 · chatgpt.com
Obsidian Canvas gives you infinite space to research, brainstorm, diagram, and lay out your ideas.
Work · 2022 · obsidian.md
- PS
Better privacy without special software
Commerce · 2022 · mprimi.github.io
Use generative AI to create future-facing videos
AI · 2022 · studio.d-id.com
