vb-software.hashnode.devSome of the Reasons Why I Prefer PostgreSQL Over MS SQL ServerThere are plenty of articles all over the internet on various PostgreSQL vs MS SQL Server topics, everybody can look for themselves. Here is one of my favorites Top 10 Reasons I like Postgres Over SQL Server that favors PostgreSQL heavily. However, ...Nov 23, 2020·19 min read
vb-software.hashnode.devPGCODE update: the execution partThe last blogpost about PGCODE was the only project introduction and description. Since then, I've added the most critical and crucial part of any SQL editor - the execution itself. This blog post will be just a report on progress and work done in t...Nov 1, 2020·9 min read
vb-software.hashnode.devPGCODE: Project description and work so farOk, what is it? PGCODE started as (and it still is) - my personal, pet-project that I've been doing for years now. Essentially, it is just another and development tool - for the PostgreSQL database.. What it does? The idea was and is to create a t...Jun 22, 2020
vb-software.hashnode.devPostgreSQL enhancements in Norm.netRecently, I've made a couple of enhancements to my Norm data access library, specifically, to simplify and improve performances when working with PostgreSQL. If you don't know already, Norm is a data-access library for .NET Core that falls into the s...Jun 17, 2020
vb-software.hashnode.devWhat have the STORED PROCEDURES ever done for us?I'll use terms stored procedures and database functions in text interchangeably. So, in all seriousness - what have the STORED PROCEDURES ever done for us? Security? You can very easily set up any database that has support for SP in a way that: You...Jun 17, 2020