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
🧑🚀 Blog for learning
database blog posts, coding tips and trick in a bitesize to help you learn database.
Connect Localhost Docker PostgreSQL in TablePlus
Tips on how to connect Localhost Docker PostgreSQL using database GUI TablePlus or sequelpro
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
Filter data by interval time (between) in mysql
oftentimes we need to filter or select data in mysql by the interval time
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
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?