OneBite.Dev - Coding blog in a bite size

🧑‍🚀 Blog for learning database

database blog posts, coding tips and trick in a bitesize to help you learn database.

Connect Production Docker PostgreSQL In TablePlus/SequelPro

Tips on how to connect production Docker PostgreSQL using database GUI TablePlus or sequelpro. Hope it works for you as well

database PostgreSQL

Connect Localhost Docker PostgreSQL in TablePlus

Tips on how to connect Localhost Docker PostgreSQL using database GUI TablePlus or sequelpro

database PostgreSQL

Migrate from firebase to Hugo

I want to migrate my firebase site (data stored in firestore) to Hugo posts. The problem is hugo made with files not database per se. Here is how i convert or migrate from firebase to hugo markdown to create post

database firebase hugo

Filter data by interval time (between) in mysql

oftentimes we need to filter or select data in mysql by the interval time

sql database

Update text between two words in mysql

How to get and update text between two words in mysql. We can use the replace method and combine in with normal Where clause

sql database

Why do we need to save created_at and update_at field in database

What is created_at and update_at field in database? why do we need to add this fields in our database?

database