Lightnews — Scholar-powered news

Reposted by Gleb Otochkin

@pgconfnyc @pgconfnyc.bsky.social · 9d

PGConf NYC would like to thank all of our speakers! The great content you presented helped make the first PGConf NYC 2025 a success! Thank you!

@PostgreSQL #postgres #conference

2 1

Reposted by Gleb Otochkin

@pgconfnyc @pgconfnyc.bsky.social · 10d

PGConf NYC would like to thank everyone who attended our conference! We hope you enjoyed the content we presented and that we’ll see you at future events!

@PostgreSQL #postgres #conference

2 2

Gleb Otochkin @skyvst.bsky.social · 10d

We've added an introduction to connectivity and what to choose when you are setting up a connection to AlloyDB. Please have a look and let us know what you think and what we are missing. goo.gle/42m8is8
@developers.google.com #AlloyDB #PostgreSQL

Choose how to connect to AlloyDB | AlloyDB for PostgreSQL | Google Cloud

Explore your options to connect to AlloyDB for PostgreSQL.

goo.gle

Gleb Otochkin @skyvst.bsky.social · 16d

Now it is even simpler to use AlloyDB through extensions from Gemini-cli!

Taylor Mullen @ntaylormullen.bsky.social · 16d

You thought we were done? 😉

Gemini CLI Drop 4: AlloyDB for PostgreSQL and BigQuery extensions for Gemini CLI!

AlloyDB for PostgreSQL: github.com/gemini-cli-e...

BigQuery:
- github.com/gemini-cli-e...
- github.com/gemini-cli-e...

🧵

#GeminiCLI #3DayDrop #AlloyDB #BigQuery #OSS

1 1

Gleb Otochkin @skyvst.bsky.social · 17d

And here we are - PostgreSQL 18 has been released! Tons of new stuff - asynchronous IO, better performance, faster upgrades, more information in EXPLAIN and and a lot of other new features.
@pgus.bsky.social
www.postgresql.org/about/news/p...

PostgreSQL 18 Released!

The [PostgreSQL Global Development Group](https://www.postgresql.org) today announced the release of [PostgreSQL 18](https://www.postgresql.org/docs/18/release-18.html), the latest version of the worl...

www.postgresql.org

1

Gleb Otochkin @skyvst.bsky.social · Aug 26

Multimodal AI models give more flexibility and options for semantic search in your data, and AlloyDB offers out-of-the-box support for Google's multimodal embeddings. Try it by yourself with the AlloyDB codelab: bit.ly/3JA9aTm. We welcome your feedback!
@developers.google.com #AlloyDB #PostgreSQL

Gleb Otochkin @skyvst.bsky.social · Aug 20

Haven't played with NL2SQL in AlloyDB yet? Yes, AlloyDB gets NL2SQL using SQL interface to configure and tune it to your data. The feature is in preview and any feedback is highly appreciated. Here is a codelab to start testing it - bit.ly/4mt7NEG
@developers.google.com #AlloyDB

Gleb Otochkin @skyvst.bsky.social · Jul 22

Have you heard about GIN? Not the beverage but the index type. It works great for JSONB but you need to remember what JSON operators are supported and what options for GIN index are available. I've written a short blog bit.ly/4kSdzOA
#Google #PostgreSQL

Gleb Otochkin @skyvst.bsky.social · Jul 17

Have you ever wondered about indexes for your JSON data type in PostgreSQL? I've written a blog about B-tree indexes for your JSON data types in PostgreSQL. bit.ly/3IOBJMi
#PostgreSQL #GoogleCloud

B-tree indexes for JSON in PostgreSQL

Introduction

bit.ly

Gleb Otochkin @skyvst.bsky.social · Jun 16

Recently we've announced that AlloyDB instances can be started and stopped. I wrote a blog with an example of start/stop automation through Cloud Scheduler, Pub/Sub and Cloud Run Functions. Have a look and try it out. bit.ly/45rdCNg

Automating AlloyDB starts and stops

Introduction

bit.ly

Gleb Otochkin @skyvst.bsky.social · Jun 4

Now you can start and stop AlloyDB instances from UI or command line to reduce cost for the dev environments when you don't need them and starting it back with the same network endpoints and parameters. Read about it in the docs goo.gle/4kpkjDU #GoogleCloud #AlloyDB

Gleb Otochkin @skyvst.bsky.social · May 29

Have you already tried the latest Google Gemini embedding model? It is available in AlloyDB out of the box in the embedding function. Read in the blog how it evaluates New York style vs Montreal bagels.
bit.ly/3ZujIbZ

State-of-the-art text embedding in AlloyDB with the latest Gemini model

Montreal style bagels are getting better recognition by the newest sate-of-the-art Google Gemini embedding model…

bit.ly

1 2

Gleb Otochkin @skyvst.bsky.social · May 23

Hi everyone! Recently we've announced a preview for some new AI operators in AlloyDB. Try it out in our new codelab and let us know what you think.
#GoogleCloud #AlloyDB #AI #Postgres
bit.ly/4dydFIX

AlloyDB AI Operators and Reranking | Google Codelabs

In this codelab you’ll learn how to deploy AlloyDB with AI operators, and use them for semantic search, joins and result ranking.

bit.ly

Gleb Otochkin @skyvst.bsky.social · May 23

Turkish tea without Turkish sweets? But yes, Turkish tea has its own special taste.

1 1

Gleb Otochkin @skyvst.bsky.social · Apr 25

My 3d Boston marathon is done. Great race and the most engaged spectators ever. If you plan to have headphones and listen to the music during the run - you will probably not hear a thing. Congrats to all runners and thanks tons to people of Boston for the hospitality! #BostonMarathon #Running

5

Gleb Otochkin @skyvst.bsky.social · Apr 22

Do you know that now Cloud SQL for MySQL has a direct integration (in preview) with Vertex AI and allows you to integrate embeddings, Gen AI or custom models calls directly into your database routines using SQL. Try our new codelab bit.ly/codelab-csql... #googledevs #MySQL

Getting started with Vector Embeddings in Cloud SQL for MySQL | Google Codelabs

In this codelab you’ll learn how to use Cloud SQL Vertex AI integration for semantic search using vectors and how to create an index on the vector data

bit.ly

Gleb Otochkin @skyvst.bsky.social · Apr 15

Have you heard that you can now create an #AlloyDB instance using the Google Axion CPU (C4A type) and with a minimal configuration of only 1 CPU and 8Gb memory. That's probably the ideal developments, demos and functional testing. Give it a try. #Postgres

Gleb Otochkin @skyvst.bsky.social · Mar 12

Are you attending Google Next? We are hosting a database professionals meetup! Come to talk about databases at Google Cloud and share your thoughts, meet new folks and let us know where we can help you. @googlecloud → g.co/cloudnext

2

Gleb Otochkin @skyvst.bsky.social · Mar 12

I’m speaking at Google Cloud Next 25 about AlloyDB Omni on Kubernetes along with local AI models on Apr-11 at 11AM PDT . Join the discussion with @GoogleCloud → g.co/cloudnext

1

Reposted by Gleb Otochkin

Guillaume Laforge @glaforge.dev · Mar 6

【 Build with Gemini / Developers Summit 】

Next Tuesday in Paris!

If you speak 🇬🇧 or 🇺🇸 (even if most of the content is in 🇫🇷) there's always one talk in English throughout the day in parallel to the French presentations!

👉 So don't hesitate to register!
cloudonair.withgoogle.com/events/build...

Build with Gemini

cloudonair.withgoogle.com

2 2

Gleb Otochkin @skyvst.bsky.social · Mar 3

Are you using a database for local development? Sometimes it is much more convenient to have a database running locally on your laptop. I wrote a short blog about using AlloyDB Omni as such a local PostgreSQL development environment on a Macbook.
#PostgreSQL #AlloyDB
medium.com/google-cloud...

AlloyDB Omni on Mac with Podman

Do you like to sink deep in an armchair with a laptop on your lap and do some development or run some tests for PostgreSQL? I do it all the…

medium.com

Gleb Otochkin @skyvst.bsky.social · Feb 27

Have you already heard that you can get coding help from Gemini Code Assist for free? By the way it can not only help with the code but also answer important questions like “What is better - Montreal or New York style bagels?”
blog.google/technology/d...

3

Gleb Otochkin @skyvst.bsky.social · Feb 18

Some time ago I wrote a blog about using AlloyDB Omni with local AI models on Kubernetes. I’ve also created a codelab to try it out in the Google GKE environment. Have a look, try it and let me know what you think.
#Postgres #AlloyDB #Omni #AI
codelabs.developers.google.com/alloydb-omni...

AlloyDB Omni and Local AI Model on Kubernetes. | Google Codelabs

In this codelab you’ll learn how to deploy AlloyDB Omni on a GKE cluster, deploy an I model to the same cluster, register the model in the AlloyDB Omni and make them working together

codelabs.developers.google.com

Gleb Otochkin @skyvst.bsky.social · Feb 10

Published a short video about RAG and interactive apps on Youtube. Have a look and let me know what you think.
(I know - another boring RAG vide) but if you are bored on Monday here it is
youtu.be/tgcixab_Yk8?...

How to build interactive Gen AI applications with Vertex AI

YouTube video by Google Cloud Tech

youtu.be

2