Posted on July 5, 2016. Filed under: Uncategorized | Tags: author:jeff-atwood, relational-algebra, sql, venn-diagram |
Here’s a couple of articles on using Venn diagrams to explain SQL joins. For… A Visual Explanation of SQL Joins – Jeff Atwood (coding horror) Since SQL joins appear to be set-based, the use of Venn diagrams to explain them seems, at first blush, to be a natural fit. However, I found that Venn diagrams […]
Read Full Post |
Make a Comment ( Comments Off on SQL joins and Venn diagrams )
Posted on September 22, 2015. Filed under: Uncategorized | Tags: databases, db2, informix, mssql, mysql, oracle, porting, postgresql, sql |
Comparison of different SQL implementations The goal of this page — which is a work in progress — is to gather information relevant for people who are porting SQL from one product to another and/or are interested in possibilities and limits of ‘cross-product’ SQL.
Read Full Post |
Make a Comment ( Comments Off on Comparison of different SQL implementations )
Posted on September 2, 2014. Filed under: Uncategorized | Tags: author:knupp, networking, nosql, python, rdbms, sockets, sql, tcpip |
What is a NoSQL Database? Learn By Writing One In Python NoSQL is a term that has become ubiquitous in recent years. But what does “NoSQL” actually mean? How and why is it useful? In this article, we’ll answer these questions by creating a toy NoSQL database in pure Python (or, as I like to […]
Read Full Post |
Make a Comment ( Comments Off on What is a NoSQL Database? Learn By Writing One In Python )
Posted on October 6, 2011. Filed under: Uncategorized | Tags: author:briang, perl, sql, triggers |
I want to apply tags to urls and keep a count of how many times each tag has been used. Here’s some code that does just that: use DBI; use Text::Table; my $FILENAME = ‘play.sqlite’; unlink $FILENAME; my $dsn = “dbi:SQLite:database=$FILENAME”; my $dbh = DBI->connect($dsn) or die; $dbh->do($_) or die “$DBI::errstr for $_” for split […]
Read Full Post |
Make a Comment ( None so far )