#sql Development Tutorials & Tips | Roast Dev

100daysofcode 100daysofdevops 100pay 10mistakes 10yearworkanniversary 11 11labs 11tly 11ty 127001

Implement an end-to-end RAG solution with watsonx.ai and Elasticsearch SQL

This tutorial was originally published on IBM Developer by Aditya Mahakali and Mohith CharanEver wondered how to tap into the power of Elasticsearch without wrestling with its entire Query DSL? Or how...

23.04.2025 0 Read More

Building a RAG System with Firebase Functions, OpenAI, and Pinecone

Few months back, I built the GenQL tool to generate SQL queries from natural text with the ability to provide context of database schema of my database to the AI. Here, I'm sharing the concepts of a b...

04.05.2025 0 Read More

How to install PostgreSQL on macOS: Step-by-Step Instructions

If you're using macOS, the steps to install PostgreSQL and set up your environment are slightly different. Here's how to do it:✅ Step 1: Install PostgreSQL on macOSOption 1: Using Homebrew (Recommen...

03.05.2025 0 Read More

Behind the Query: The Secret Life of Database Indexes

Hi developers, I hope your database queries are not taking much time to find the records. But if they are... well, that's why I am writing this article.Before diving into the secret life of our databa...

04.05.2025 0 Read More

Text-to-SQL from Scratch — Tutorial For Dummies (Using PocketFlow!)

Ever wished you could just ask your database questions in plain English instead of wrestling with complex SQL queries? This guide breaks down Text-to-SQL in the simplest way possible using the Pocket...

23.04.2025 0 Read More

Summarize Row Counts by Dynamic Columns into JSON — From SQL to SPL #22

Problem description & analysis: Each column of database table tempdata can be viewed as an array, with duplicate members:Task: Now we need to group and count each column separately, in JS...

23.04.2025 0 Read More

2nd,Create Tables In Supabase

create Profile table to save user's general info as we have setup Google Auth in the last step, we need a table to save user's info ⛶CREATE TABLE public.profiles ( id UUID NOT NULL PR...

24.04.2025 0 Read More

How To Set Up Multiple Datasources in Spring Boot 3

Separating data into different databases is a typical approach in the microservices world. This means that each backend usually needs to access only its limited database. At the same time, a backend a...

24.04.2025 0 Read More

How to Map a JSON Column in Spring Boot With JPA 3 and Hibernate 6

Building a RESTful application in Spring Boot that reads data from a database requires the definition of some ORM mappings. Even though this is generally a boring task, it is crucial for the proper fu...

24.04.2025 0 Read More

How to supplement the missing capabilities of database SQL with esProc

Some database SQL lacks necessary capabilities and usually requires writing large sections of code to indirectly implement similar functions. In some cases, stored procedures are even used to drive ar...

24.04.2025 0 Read More

Implement an end-to-end RAG solution with watsonx.ai and Elasticsearch SQL

Building a RAG System with Firebase Functions, OpenAI, and Pinecone

How to install PostgreSQL on macOS: Step-by-Step Instructions

Behind the Query: The Secret Life of Database Indexes

Text-to-SQL from Scratch — Tutorial For Dummies (Using PocketFlow!)

Summarize Row Counts by Dynamic Columns into JSON — From SQL to SPL #22

2nd,Create Tables In Supabase

How To Set Up Multiple Datasources in Spring Boot 3

How to Map a JSON Column in Spring Boot With JPA 3 and Hibernate 6

How to supplement the missing capabilities of database SQL with esProc

#reading

#popular