search
Follow Topic rss_feed

The Marten library provides .NET developers with the ability to use the proven PostgreSQL database engine and its fantastic JSON support as a fully fledged document database. The Marten team believes that a document database has far reaching benefits for developer productivity over relational databases with or without an ORM tool.

Bharat Dwarkani shared on May 23, 2020
image
github.com
bookmarks
share
visibility0
visibility0 share bookmarks

It’s been a while since PostgreSQL implemented support for JSON columns in its tables. Basic at the beginning, now it offers a lot of functionality that can come in handy when you have a PostgreSQL database, and make use of some of its cool stuff (like the ton of functions of PostGIS), but also need to store some non-structured data or with a user-defined schema.

Bharat Dwarkani shared on May 22, 2020
image
link.medium.com
bookmarks
share
visibility7
visibility7 share bookmarks

Directly query custom PostgreSQL functions in the GraphQL API

Bharat Dwarkani shared on May 22, 2020
image
github.com
bookmarks
share
visibility18
visibility18 share bookmarks

How you can set up your local development database using docker. Fast and simple.

Bharat Dwarkani shared on May 17, 2020
image
towardsdatascience.com
bookmarks
share
visibility12
visibility12 share bookmarks

Database script for creating readonly user in PostgreSQL

Bharat Dwarkani wrote on May 10, 2020
image
sharetechlinks.com
bookmarks
share
visibility13
visibility13 share bookmarks

In this short blog post we will connect DBeaver to Google Cloud SQL (PostgreSQL) in two ( and a half ) different ways. First we will look at the recommended way of using the local Cloud SQL Proxy and secondly we will look at how-to hook up DBeaver directly to Cloud SQL using a secure connection.

Bharat Dwarkani shared on May 10, 2020
image
medium.com
bookmarks
share
visibility980
visibility980 share bookmarks

PostgreSQL 12 comes with a great new feature, Generated Columns. A Generated Column is a special column in a table that contains data automatically generated from other data within the row. The content of the generated column is automatically populated and updated whenever the source data, such as any other columns in the row, are changed them

Bharat Dwarkani shared on May 10, 2020
image
severalnines.com
bookmarks
share
visibility5
visibility5 share bookmarks

In Depth series of posts on managing PostgreSQL in different cloud vendors AWS, Digital Ocean, GCP, Azure

Bharat Dwarkani wrote on May 09, 2020
image
sharetechlinks.com
bookmarks
share
visibility2
visibility2 share bookmarks

Benchmark comparison of AWS Aurora, AWS RDS, Google Cloud Platform (Cloud SQL), Microsoft Azure PostgreSQL

Bharat Dwarkani wrote on May 09, 2020
image
sharetechlinks.com
bookmarks
share
visibility13
visibility13 share bookmarks

In MySQL or MariaDB we have generic, well performing solution like InnoDB, which works fine in majority of the cases, but we also have separate functions to work with JSON data, separate spatial indexes to speed up querying geometric data or fulltext indexes, helping with text data. In this blog, we will take a look at how MariaDB can be used to work with full text data.

Bharat Dwarkani shared on May 09, 2020
image
severalnines.com
bookmarks
share
visibility5
visibility5 share bookmarks
add