postgressql - CybAI news

30 Nov

PostgreSQL Full Text Search Rank by Position

stp2y0 CommentsNewscoding, community, development, engineering, inclusive, postgressql, software, tutorial

Recently, I encountered a problem with full-text search. I am using this feature in my search input, where the backend sends hints of possible matches as you type. The backend database is PostgreSQL. I needed the hints to be ranked by the position of the searched term in the text. Full Text Search in PostgreSQL Full-text search in PostgreSQL can be achieved quite easily. There are two main tools to use: tsvector - represents a searchable document. tsquery - represents the search query to perform against a document. Let’s say we want to search the titles of our blog posts.…

Migrating from MySQL to PostgreSQL

stp2y0 CommentsNewscoding, community, development, engineering, inclusive, mysql, perl, postgres, postgressql, software

Migrating a database from MySQL to Postgres is a challenging process. While MySQL and Postgres do a similar job, there are some fundamental differences between them and those differences can create issues that need addressing for the migration to be successful. Where to start? Pg Loader is a tool that can be used to move your data to PostgreSQL, however, it's not perfect, but can work well in some cases. It's worth looking at to see if it's the direction you want to go. Another approach to take is to create custom scripts. Custom scripts offer greater flexibility and scope…

Free Database Hosting

stp2y0 CommentsNewscoding, community, database, development, engineering, inclusive, mysql, postgressql, redis, software

When it comes to free database hosting, several providers offer robust solutions across various database systems including MySQL, PostgreSQL, MongoDB, and Redis. Here are some of the top options available in 2024: 1. MySQL Google Cloud Platform (GCP) Features: GCP offers a free tier that includes the Cloud SQL service for MySQL. Users can manage and maintain their MySQL databases with automatic backups, updates, and scaling. Free Tier Limits: GCP’s free tier provides a small instance with 30GB of HDD storage and 1GB of RAM per month. Pros: High availability, seamless integration with other Google Cloud services, and robust security…