Articles on sql

Formatted SQL in Python with Psycopg’s Mogrify

Formatted SQL in Python with Psycopg’s Mogrify

In this Compose Write Stuff Addon, Lucero Del Alba takes a look at the problem of viewing queries sent to a server, and how t…

Guest Author
Picking SQL or NoSQL? – A Compose View

Picking SQL or NoSQL? – A Compose View

Here's a question we hear a lot - Should I use SQL databases or NoSQL databases? It's a question that gets asked because ofte…

Dj Walker-Morgan
Dj Walker-Morgan
Compose's Little Bits #22: CitusDB, SQL Injection, Parallel Aggregation, Dragons, Markdown and more

Compose's Little Bits #22: CitusDB, SQL Injection, Parallel Aggregation, Dragons, Markdown and more

Citusdata goes open source with Citus 5.0, SQL Injections documented, Parallel Aggregation for PostgreSQL 9.6, Facebook's Dra…

Dj Walker-Morgan
Dj Walker-Morgan
Compose's Little Bits #16 - PostgreSQL, RethinkDB, LIGO, htop

Compose's Little Bits #16 - PostgreSQL, RethinkDB, LIGO, htop

PostgreSQL updates and advice, RethinkDB on Windows, SQL querying LIGO data, CSV on the Web, Parse updates, htop, securityhea…

Dj Walker-Morgan
Dj Walker-Morgan
"2","Extracting and Working with CSV files"

"2","Extracting and Working with CSV files"

In the first part of "Comma Values", we got CSV formatted data out of MongoDB. Now,in part two, we're going to look at the to…

Dj Walker-Morgan
Dj Walker-Morgan
Using JSON Extensions in PostgreSQL from Python

Using JSON Extensions in PostgreSQL from Python

In this Write Stuff article, Ryan Scott Brown takes a look at how you can work with PostgreSQL's JSON and JSONB support from…

Guest Author
What PostgreSQL has over other open source SQL databases: Part II

What PostgreSQL has over other open source SQL databases: Part II

PostgreSQL's tag line claims that it's "The world's most advanced open source database." In Part I of this series we looked a…

Lisa Smith
Lisa Smith
What PostgreSQL has over other open source SQL databases: Part I

What PostgreSQL has over other open source SQL databases: Part I

You may be asking yourself "Why PostgreSQL?" There are several choices for open source relational databases out there (we loo…

Lisa Smith
Lisa Smith
DigData on Implementing SQL for MongoDB

DigData on Implementing SQL for MongoDB

This is a guest post from full-stack engineer Alon Horev on how to get more from your MongoDB deployment with SQL-like querie…

Guest Author

Analytics & Reporting on Compose: Use SQL to Understand Your MongoDB Data

This is a guest article by John A. De Goes, CTO of SlamData. SlamData is the commercial company behind the open source proje…

Dj Walker-Morgan
Dj Walker-Morgan