Viewing profile — vbilopav

This was my first approach in realizing my PostgreSQL-centric, Db-first, or rather SQL-first vision of software development. The project was call pgroutiner and it generated bunch …

Why not Foreign Data Wrappers?

NpgsqlRest Automatic PostgreSQL Web Server Create REST APIs for PostgreSQL databases in minutes. https://npgsqlrest.github.io/ - one man project (me) - been doing it well over a ye…

It looks to me team is clueless about database development. Typescript ORMz lol. Soft deletes make indexing, well, problmatic to say at least. Use temporal tabls instead for point …

What an awful query example! This should and is simple. Here: select jsonb_build_object( 'title', title, 'genres', genres, 'actors', json_agg( jsonb_build_object( 'name', actor_nam…

I did some testing on PostgreSQL 17 and found out that this special function 8s not needed.

why does it look like SQL?

It's already built into code to check does trigger exists, check it out. As far as changes(alter table ) goes, I need to take history tables into consideration when writing migrati…

Please don't do this. It's a design/ architectural sin. It messes up your queries, commands and indexes and it's constant source of trouble. Here's a better way: https://medium.com…

I thought it was because of Eurovision

Here's an alternative I've built for myself https://github.com/vb-consulting/NpgsqlRest

I'll just keep on using Svelte 4