Shrawan Sharma @DBA_SyncAI

A fix for dumping bytea with total size of the escape/hex output exceeding 1Gb

PostgreSQL @PostgreSQL

2 years ago

A fix for dumping bytea with total size of the escape/hex output exceeding 1Gb

0 4 23 4K 2

David Wheeler (@theory): RFC: Extension Metadata Typology postgr.es/p/6mQ

Gülçin Yıldırım Jelínek: The Builders Podcast Recap: Unlocking Postgres Power: A Deep Dive on Simplifying High Av... postgr.es/p/6o2

Raouf Chebri: pgvector: 30x Faster Index Build for your Vector Embeddings postgr.es/p/6m3

PgCat, the connection pooler with multithreading, seems better for high concurrent connections, can be tested for 5k or more concurrent connections.

Planet PostgreSQL @planetpostgres

2 years ago

PgCat, the connection pooler with multithreading, seems better for high concurrent connections, can be tested for 5k or more concurrent connections.

1 24 68 5K 30

Worth trying !

Planet PostgreSQL @planetpostgres

2 years ago

Worth trying !

0 3 11 2K 3

Karen Jex (@karenhjex): Learning about "transqlate" at PG Session 16 postgr.es/p/6lP

The latest version of pgvector extension provides improvements in performance, memory efficiency, and WAL generation for building hnsw indexes.

PostgreSQL @PostgreSQL

2 years ago

The latest version of pgvector extension provides improvements in performance, memory efficiency, and WAL generation for building hnsw indexes.

0 2 10 3K 3

MySQL 8.3.0 arrived last week. Once change, that didn't make it into the releasnotes nor in the documentation is that it now accepts the standard SQL ROLLUP syntax in GROUP BY. Previously, it had only the non-standard WITH ROLLUP extension. modern-sql.com/caniuse/rollup

With the lastest release, from 2023, the SQL standard finally legalized not specifying the maximum length of variable length string types — e.g. VARCHAR. modern-sql.com/caniuse/T081

Here is a step by step explanation of building a Generative question answering system from scratch in Python 🔥 Let's also log and track every chat completions generated in your scripts! Thread🧵👇

TIL that SQL Server trace flag 3625 masks errors for low-security users. Neat: patrickkeisler.com/2023/12/how-to…

One of the best use cases of AI is code generation, though it gives many headaches. Well, the latter is changing fast! AlphaCodium has just been released and it improves GPT-4 accuracy by 25% in specific datasets. More details below:

RAG-Enabled LLMs On Web Search LLMs are extremely good at information retrieval and organization at scale. Systems that combine web search and LLMs make for extremely powerful tools that can help inform and educate us on any topic. It's like you have all of humanity's…

New blog post by @mraasveldt: Multi-Database Support in DuckDB duckdb.org/2024/01/26/mul… DuckDB can now attach MySQL, Postgres, and SQLite databases in addition to databases stored in its own format. This allows data to be read into DuckDB and moved between these systems in a…

Python library that adds Generative AI capabilities to Pandas🔥 Introducing PandasAI, now you can analyze complex data frames and plot visualizations just by using natural language Thread🧵👇

Introducing 'Prompt Engineering with Llama 2' — an interactive guide covering prompt engineering & best practices for developers, researchers & enthusiasts working with large language models. Access the notebook in the llama-recipes repo ➡️ bit.ly/3Hu266D

Matrix Multiplication: Optimizing the code from 6 hours to ~ 1 sec. "Performance Engineering is a lost art." - Charles Leiserson youtu.be/ywKyR_8Yi00?si… I followed this lecture - youtu.be/o7h_sYMk_oc?si… medium.com/p/70889d33dcfa

🆕 Build apps with Neon & DronaHQ Learn how you can build apps using Neon and @DronaHQ, a low-code app development platform ✨ In this guide by @Aaikansh_22, you'll build an AI-powered lead management app ↓ bit.ly/3vLwVAQ

Using Vector Databases to Scale Multimodal Embeddings & Search: youtube.com/watch?v=2sOUu8… + #VectorDB for #GenerativeAI Applications: medium.com/@bijit211987/p… + VectorDB in #AI landscape: medium.com/international-… ————— #MachineLearning #DeepLearning #LLMs #BigData #DataScience #GenAI