Articles related to SQL from the team that helps B2C companies build and defend revenue with AI.
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
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_