#query-builder #sql #postgresql #client #conn #sql-client #extentions

simple_pg

Provides extentions and utilites for working with postgres

15 releases

0.5.8 Apr 12, 2025
0.5.7 Nov 15, 2024
0.5.5 Oct 15, 2024
0.5.0 Apr 11, 2024
0.4.1 Feb 7, 2024

#826 in Database interfaces

MIT license

32KB
744 lines

simple_pg

A work in progress series of crates to simply working postgreSQL in rust. Based on:

Primary Goals:

  • Deeply integrate query builder.
  • Unify client types so generic client isn't needed. Replaced by impl Deref<Conn>.
  • Provided methods for fast & parallel unit testing via schema universes.
  • Optimize performance for our use cases.
  • Reduce incremental compile times via reducing monomorphization.

Features

SQL macro

    sql!(INSERT INTO schema.table VALUES(
        { entity.id },
        "some_text",
        ST_SetSRID({ geometry }), 4326)
    )).execute(&mut tx)?;

Dependencies

~7–17MB
~219K SLoC