vbilopav

5 ms·

1.
Tests Are SQL Files Too(npgsqlrest.github.io)
3 points by vbilopav 3mo ago|0 comments
2.
PostgreSQL REST API from SQL Scripts(npgsqlrest.github.io)
1 points by vbilopav 5mo ago|0 comments
3.
by vbilopav 6mo ago
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 of C# code for me out of PostgreSQL. After doing couple of p
4.
Show HN: End-to-End Static Type Checking: PostgreSQL to TypeScript(npgsqlrest.github.io)
1 points by vbilopav 9mo ago|0 comments
5.
PostgreSQL REST API Benchmark: 15 Frameworks Compared(npgsqlrest.github.io)
1 points by vbilopav 9mo ago|0 comments
6.
Show HN: NpgsqlRest Automatic PostgreSQL Web Server(npgsqlrest.github.io)
2 points by vbilopav 9mo ago|0 comments
7.
by vbilopav 11mo ago
Why not Foreign Data Wrappers?
8.
by vbilopav 11mo ago
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 year now - no sponsorship, no investors, no b
9.
by vbilopav 1y ago
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 in time recovery. Nevertheless it could have been solved on
10.
by vbilopav 1y ago
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(
11.
by vbilopav 1y ago
I did some testing on PostgreSQL 17 and found out that this special function 8s not needed.
12.
by vbilopav 1y ago
why does it look like SQL?
13.
I Always Use PostgreSQL Functions for Everything(medium.com)
4 points by vbilopav 2y ago|0 comments
14.
Automatic Temporal Tables Schema Management with PostgreSQL(medium.com)
2 points by vbilopav 2y ago|1 comments
15.
by vbilopav 2y ago
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 migration scripts. Since I'm doing my migrations always w
16.
by vbilopav 2y ago
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/@vbilopav/cus
17.
by vbilopav 2y ago
I thought it was because of Eurovision
18.
by vbilopav 2y ago
Here's an alternative I've built for myself https://github.com/vb-consulting/NpgsqlRest
19.
by vbilopav 2y ago
I'll just keep on using Svelte 4
20.
Automatic REST API from PostgreSQL Databases, Implemented as .NET8 Middleware(vb-consulting.github.io)
2 points by vbilopav 2y ago|0 comments
21.
How DDD is screwing up your SQL(vb-consulting.github.io)
2 points by vbilopav 3y ago|0 comments
22.
NpgsqlRest(vb-consulting.github.io)
1 points by vbilopav 3y ago|0 comments
23.
Pg_schema_tools(github.com)
3 points by vbilopav 3y ago|0 comments
24.
by vbilopav 3y ago
He hates TypeORM but loves Prisma and Prisma can't even do joins, it's doing N+1 by default and always. What does TypeORM do then?
25.
by vbilopav 3y ago
Just use temporal tables https://github.com/vb-consulting/blog/discussions/7
26.
by vbilopav 3y ago
I wonder how our ancestors ever managed to do anything let alone build a world we live in without having someone to teach them empathy. It's ridiculous. We have a pandemic of narcissism thanks to social media and when they see this the
27.
by vbilopav 3y ago
https://github.com/vb-consulting/blog/discussions/5
28.
Recursion with PostgreSQL, Follup 1, Perfomances(github.com)
3 points by vbilopav 3y ago|1 comments
29.
by vbilopav 3y ago
I wrote a follow-up on yesterday's article on tree processing and recursion with PostgreSQL. This one: https://github.com/vb-consulting/blog/discussions/1 SQL was never intended for this kind of stuff; I
30.
by vbilopav 3y ago
A follow up on this article was written today [Recursion with PostgreSQL, Follup 1, Perfomances]( https://github.com/vb-consulting/blog/discussions/4 ) I managed to get some really good perfomances (757K record

More ›