SQL

Articles related to SQL from the team that helps B2C companies build and defend revenue with AI.

11 Nov 2017 • 1 min read

How to read CREATE TABLE SQL with pg_query

pg_query is a really cool Ruby library that uses Postgres's query parser to give you programmatic access to SQL queries. One thing you can do with it is read a CREATE TABLE statement to map column names to column types: sql = <<-SQL CREATE TABLE example ( my_text

Read more

25 Oct 2016 • 1 min read

How to use Postgres cursors and multi-insert in Ruby with Sequel

This post is part of our PostgreSQL series. SQL cursors are a great way to stream data out of a database without loading it all into memory. Reading using a cursor Sequel has use_cursor: BATCH_SIZE = 1000 DB[:widgets]. select(:id, :name, :power). use_cursor(rows_per_fetch: BATCH_

Read more