OPENGIS.ch’s Post

Setting up a pg_service.conf file on windows has finally become as easy as it should be. Great tool, informative post. 🚀

You probably don't need a vector database. Postgres is still all you need My recent blog post spurred some interesting discussions around databases on HN and Reddit 🐘 Read about working with vector embeddings in Postgres, the launch of pgvectorscale and benefits of colocating data. If you're working with vector embeddings or considering using a vector database, this post is for you. Link to full post in comments 👇 Let me know what you think #postgres

Multi-Table Joins in PostgreSQL | Learn Spatial DB with PostGIS, QGIS | Part 10 Unravel the secrets of multi-table joins in PostgreSQL with this advanced course designed to give you the basic skills to retrieve data from multiple tables! https://lnkd.in/gy7X8ArY

Here are 3 types of scan you didnt know about in postgres Sequential Scan Index Scan & Bitmap Heap Scan Use the EXPLAIN or EXPLAIN ANALYZE infront of your Query Outputs the type of scan, the planning time and the execution time

Here are 3 types of scan you didnt know about in postgres Sequential Scan Index Scan & Bitmap Heap Scan Use the EXPLAIN or EXPLAIN ANALYZE infront of your Query Outputs the type of scan, the planning time and the execution time

Interested in on-the-fly geospatial conversion tools but don't want to rely on a random website or a GUI ? Try xyzeus's suite of nearly 100 conversion functions. Supported conversion formats in include geojson, shapefile, KML, WKT, H3, geoparquet, geodataframe, geohash, GPX, GeoPackage, topojson, postgreSQL, SQLite, DXF and many more ! A few geojson conversion methods have been listed below...

Ready to set up your FaunaDB database and establish a store? Dive into this tutorial and get your backend ready to power your application. #FaunaDB #Database #WebDevelopment #Tutorial #Backend Watch now: [https://lnkd.in/gJqZQ4A3]

Using DuckDB to read parquet files and loading these into #postgres works surprisingly well. It’s possible to connect to Postgres db from DuckDB with one line of code. However, if you work with geo data the DuckDB spatial extension is not compatible with the Postgres gis extension. This means we can’t save geometry type data directly to Postgres from DuckDB. Alternatively save the geo data as WKT and in Postgres update the table by converting to geometry. #dataengineering

Postgres is quickly becoming the most loved database by developers, so it makes sense that developers would turn to #pgvector to build #RAG applications. Timescale Vector brings blazing fast performance and easy management to the picture.

Thinking minimalistically is common among both beginners and experts. They often choose Postgres as a vector database instead of a more complex dedicated one. Watch this video to learn about Postgres’ pgvector extension for billion-scale vector search 🎥 https://lnkd.in/eYgChrxx