Skip to content

Latest commit

 

History

History
51 lines (42 loc) · 1.21 KB

README.md

File metadata and controls

51 lines (42 loc) · 1.21 KB
Raw
SynthQL

SynthQL

A full-stack, type-safe client to your PostgreSQL database with a focus on DX and performance.

Show me some code

import { QueryEngine } from '@synthql/backend';
import { from } from './generated';

export const queryEngine = new QueryEngine({
    url: 'postgresql://user:password@localhost:5432/dbname',
});

const query = from('films')
    .columns('id', 'title', 'year')
    .filter({ id: { in: [1, 2, 3] } })
    .all();

const data = await queryEngine.executeAndWait(query);

// `data` will resolve to:
[
    {
        id: 1,
        title: 'The Lord of the Rings: The Fellowship of the Ring',
        year: '2001',
    },
    {
        id: 2,
        title: 'The Lord of the Rings: The Two Towers',
        year: '2002',
    },
    {
        id: 3,
        title: 'The Lord of the Rings: The Return of the King',
        year: '2003',
    },
];

Links