docteurklein

;

drop function if exists explore(text);
create function explore(sql text) returns setof record
language 'plpgsql' as $$
begin 
    return query execute format($sql$
        with node (tableoid, row) as (
            %s
        ),

docteurklein

drop function if exists exec(text, text[]);
create function exec(sql text, params text[] default '{}') returns void
language 'plpgsql' as $$
begin 
    execute format(sql, variadic params); 
end 
$$;
-- select exec('select 1');

drop function if exists query(text, text[]);

docteurklein

load 'age';
SET search_path = ag_catalog, "$user", public;

create table if not exists history (year, event) as values (1996, 'postgresql'), (2016, 'agensgraph');

select drop_graph('g', true);
select create_graph('g');

select * from cypher('g', $$
    create (:dev {name: 'someone', year: 2015})

docteurklein

declarative DDL

what?

Define your database schema in a declarative way, by providing the wanted state, and this tool will calculate a diff to reconcile it with reality.

how?

Let's imagine a scenario:

docteurklein

Work on a cabal dependency to contribute upstream

The haskell dependency management can be quite intimidating at first, but after a while you get used to it and realize it's very similar to rust's cargo (so many things are similar between rust and haskell, by the way).

One of the things I found particularly easy (once you know how) is to edit a dependency locally to work on it.

So imagine you have a cabal project with a dependency:

docteurklein

use Doctrine\DBAL\Schema\Comparator;
use Doctrine\DBAL\Connection;
use Doctrine\DBAL\Configuration;
use Doctrine\DBAL\DriverManager;

$connFrom = DriverManager::getConnection([
    'url' => "mysql://root:[email protected]/test1",
], new Configuration);

$connTo = DriverManager::getConnection([

docteurklein

create table if not exists migration (
    id bigint primary key,
    at timestamptz not null default clock_timestamp()
);

docteurklein

begin;

create table if not exists migration (id bigint primary key, at timestamptz not null default clock_timestamp());


drop function if exists migrate;
create function migrate() returns bigint language plpgsql as $$
declare current_migration bigint;
begin
    select coalesce((select id from migration order by id desc limit 1), 0) into current_migration;

docteurklein

create function es.project(event es.events) returns void
language plpgsql as $$
begin
    case event.type
        when 'user_registered' then
            insert into es.active_users
            (user_id            ,  name                   ,  sha256                   ,  updated_at) values
            (event.aggregate_id ,  event.payload->>'name' ,  event.payload->>'sha256' ,  event.added_at);
        when 'user_changed_password' then
            update es.active_users set

docteurklein

error[E0599]: no method named `map` found for type `postgres::notification::BlockingIter<'_>` in the current scope
  --> src/main.rs:24:19
   |
24 |     notifications.map(|notification| {
   |                   ^^^
   |
   = note: the method `map` exists but the following trait bounds were not satisfied:
           `&mut postgres::notification::BlockingIter<'_> : fallible_iterator::FallibleIterator`
 `&amp;mut postgres::notification::BlockingIter&lt;'_&gt; : std::iter::Iterator`