PostgreSQL features you didn’t know about 👩‍💻 #programming #code #technology #tech #software

[bettermanlamia]

I love the mention of json. Being able to query it in place is handy. Until you have a giant nested json structure then those queries are a nightmare, but that's the nature of large datasets

[coderentity]

And stores vectors and can index them for your AI project, and stores and queries spatial data, and does full text search and can do async notifications on data change and it isn't slow at all

[bbbenjoo]

Met a guy who build a whole crud backend and frontend directly with postgres.

[kfizzle]

You can do recursive queries in mysql too. Also why no mention of pg_notify/pubsub or array types?

[a.v]

Im trying to learn GTK, learning through documentation is really hard! Any tips or sources?

[anirudhmanojc.v]

as a keen content developer, i would like to know from where u get ur stock videos / animations

[cee]

This is actually true. I work with Django in python and I'm actually able to store JSON data in something called the JSON field. It's actually very useful as I don't have to create a new database model for the simplest stuff.

[Aminsx_]

Why do i use postgresql?

Efficient? No
Feautures? No
Cute logo? yes

[Bogsso]

PostgreSQL -> WhateverDB😂
It has so much functionalities and use cases.

[prgrmr]

I didn't really wanna say it but you've been generalizing a lot of opinions in this channel lately, such as saying: "you may not need a nosql database"