Articles related to SQL from the team that helps B2C companies build and defend revenue with AI.
pg_query [https://github.com/lfittl/pg_query] is a really cool Ruby library that uses Postgres [http://postgresql.org/]'s query parser to give you programmatic access to SQL queries. One thing you can do with it is read a CREATE TABLE [https://www.postgresql.org/docs/9.6/
This post is part of our PostgreSQL [https://faraday.ai/blog/tag/postgres] series. SQL cursors [https://en.wikipedia.org/wiki/Cursor_(databases)] are a great way to stream data out of a database without loading it all into memory. Reading using a cursor Sequel [https://github.com/jeremyevans/sequel]