Database Schema Samples

Barry Williams' library of 'Kick-Start' Data Models is a great resource to check when starting work on designing a database schema (Thanks ScottGu)


Comments

Post a Comment

Popular posts from this blog

HOW TO Filter Products on Open Food Facts by Country (India) Using DuckDB & Superset

Image
Open Food Facts (OFF) is a crowd-sourced database of food products from around the world.  Somewhere in the world, a shopper scans the barcode on a packet of biscuits and adds basic product details. Another person photographs a package label for the same product in Hyderabad. A volunteer in France fixes a typo.  That's Open Food Facts, a volunteer-built, openly licensed database of food products that's continually changing and growing. Each product is identified by a barcode and carries ingredients, nutrition facts, brands, labels and more. The whole database has millions of products, and let's say you only want the products recorded as being sold or available in one country like India. There are multiple ways to extract a subset of the OFF database. I have already tried using the daily dump available on Hugging Face through Google Colab and GitHub Actions in the past but it blew my mind that using the OFF deployed Apache Superset , you can execute a SQL query in a brows...
Read more

This Week I Learned - Week 41, 2026

Image
This Week I Learned -  * " We are making Markdown files work natively across Google Drive and Docs. You can now preview .md files in Drive, open them in Docs, edit them, comment on them, and collaborate without converting the file into a Google Doc! Markdown has become the common language between humans and AI agents - specs, plans, READMEs, tables, task lists, generated docs - so much of this starts as .md. Now you can keep the file as Markdown and still use Google Docs collaboration workflows. " - Chandu Thota , VP at Google * Article 50(2) of the EU AI Act requires providers of generative AI systems to ensure AI-generated or manipulated content, including text, is marked in a machine-readable format and detectable as artificially-generated or manipulated.  OpenAI will begin adding an invisible watermark to eligible text generated by ChatGPT and Codex in the European Union (EU). OpenAI's text watermarking technology, called textGrain, adds an invisible statistical signa...
Read more