sql: add queries (with embrace)

1 files changed, 9 insertions, 2 deletions

diff --git a/flake.nix b/flake.nix
index e09265f..578bb9b 100644
--- a/flake.nix
+++ b/flake.nix
@@ -4,7 +4,9 @@
 
 {
   inputs = {
-    nixpkgs.url = "github:NixOS/nixpkgs/nixos-21.05";
+    # for python3Packages.embrace: https://github.com/NixOS/nixpkgs/pull/131425
+    nixpkgs.url = "github:pacien/nixpkgs/3faf31d";
+    #nixpkgs.url = "github:NixOS/nixpkgs/nixos-unstable";
     flake-utils.url = "github:numtide/flake-utils";
   };
 
@@ -13,8 +15,13 @@
   with import nixpkgs { inherit system; };
   let
 
-    develPackagesAndScripts = [
+    python = python39;
+
+    develPackagesAndScripts = with python.pkgs; [
       postgresql_13  # PostgreSQL server with the standard admin tools.
+      ipython        # Interactive Python REPL for experimenting.
+      psycopg2       # PostgreSQL driver for Python
+      embrace        # bridges raw SQL queries to Python functions
 
       # More pleasant alternative to psql, with colours and auto-completion.
       # Custom configuration to suppress irrelevant warnings and messages.