#sql
6 notes and posts, 40 links.
Notes and posts
Evidence
Evidence is "Business Intelligence as Code"; which means it allows you to build reports, and standard business data visualization ( charts, and basic graphics) using sql with markdown as the glue between various data…
LLMs in Data Management
[@10.14778/3611479.3611527]; PDF We argue that the disruptive influence that LLMs will have on data management will come from two angles. (1) A number of hard database problems, namely, entity resolution, schema…
Data Apps
Data applications (usually), web application frameworks that make it easy to publish data as dynamic reports that have an element of interactivity to them that is not possible in static reports, they are often…
Query Languages
There is of course sql.. and PRQL -- Pipelined Relational Query Language, pronounced “Prequel”. The web page has good examples and the advantages; probably the most promising looking of these query languages I have…
PostgreSQL
Why PostgreSQL PostgreSQL is Enough; and Just Use Postgres for Everything. Just use Postgres Quickstart Pedram Navid | A Fast, Sample Postgres Database with Docker Learning PostgreSQL DBA Roadmap: Learn to become a…
SQL
SQL Words ( via ) On SQL Modern Data Practice and the SQL Tradition | Florents Tselai 12 Common Mistakes and Missed Optimization Opportunities in SQL | Haki Benita I Don't Need Your Query Language Your Database Skills…
Links Open in the Archive
The DuckDB Local UI
can have multiple databases including in memory database attached. Can explore the databases using Table summary, the notebooks are useful in organizing work…
Pinboard Database Schema
the mysql database schema that powers pinboard.in. useful if you are trying to create your own pinboard like service. sql -- MySQL dump 10.13 -- -- Pinboard…
looker-open-source/malloy: Malloy is an experimental language for describing data relationships and transformations.
Practical SQL for Data Analysis | Haki Benita
use sql instead of reaching for pandas..
Your migrations are bad and you should feel bad - djrobstep.com
The case against ORMs
Why SQL is neither legacy, nor low-level, nor difficult, nor the wrong place for (business) data logic, but is simply awesome!
A Visual Explanation of SQL Joins
ScalikeJDBC
adeven/rport
Rport - Business Intelligence apps with SQL and R
Liquibase | Database Refactoring | Faq
Tracking, managing and applying database changes.
Database development mistakes made by application developers - Stack Overflow
SQL Toolbelt - All our SQL Server tools in a single installer
according to this comment: http://www.reddit.com/r/programming/comments/eie3z/atablethatshouldexistinallprojectswitha/c18bpbs on reddit, "This is not a sales…
MySQL Tips
EXPLAIN EXTENDED: efficient database queries in SQL.
PostgreSQL Metadata Function (Field name, type, length, etc)
Extracting META informations from PostgreSQL (INFORMATION_SCHEMA) - Lorenzo Alberton
Extracting META informations from PostgreSQL using INFORMATIONSCHEMA and table catalogs
Aggregate Navigation With (Almost) No Metadata
Library of Free Data Models
Here are some useful 'Kick-Start' Data Models
Defying Classification: Custom SQL In Django
For people wanting to write custom SQL queries for use in Django and are wondering how to make them "fit in" somehow with the rest of your code, a short…
Using the SQLObject Support package
a nice tutorial on using sqlobject with Zope3.Yoohoo!!
MDB Tools
library to access Microsoft MDB format database data from Linux
Comparison of Oracle, MySQL and PostgreSQL DBMS
SQL Designer
Connecting databases to Python with SQLObject
MySQL Gotchas
Comparison of different SQL implementations
PostgreSQL Cheat Sheet
Database Programming and Design
Designing the Star Schema Database
- More links