All Posts
Filtering by: sql

Posts tagged "sql"

4 posts found

Browse by topic

All amqp angular apache api api-development app-router architecture async authentication automation backend beginners blade bun caching career ci-cd class-components code-reuse code-splitting comparison componentdidmount createslice cron crud custom-hooks data-fetching database deno dependency-injection deployment design-patterns developer-experience devops distributed-systems eloquent email embedded engineering error-boundaries error-handling event-bus events express facades fastify file-storage framework frameworks frontend fullstack functional-components global-state history hono htaccess java javascript jobs jotai json jsx jwt laravel laravel-5.6 learn-react linux listeners logging maven message-queue microfrontends microservices middleware migrations mobile module-federation mvc mybatis mysql nexmo nextjs nodejs notifications optimization orm performance php postgres postgresql production prop-drilling pub-sub queues rabbitmq react react-18 react-components react-context react-ecosystem react-error-boundary react-hooks react-lazy react-lifecycle react-memo react-performance react-query react-server-components react-state react-suspense react-tutorial redis redux redux-thunk redux-toolkit reflection resilient-apps rest rest-api rsc rtk rtk-query s3 scheduling security seeding server server-rendering service-container setstate side-effects simplicity sms solid spring-boot spring-security spring-tutorial sql sqlite ssl ssr state-management svelte swagger tanstack-query twilio typescript uploads usecallback usecontext useeffect usefetch usememo usestate vps vue web-development webpack zustand
🔧 Engineering

PostgreSQL: The Database That Does Everything (And Why It's My Default Now)

I started with MySQL. I dabbled with SQLite. Then I tried PostgreSQL, and I understood why experienced developers get weirdly passionate about it. JSON columns, full-text search, window functions, CTEs, JSONB indexing—Postgres isn't just a database, it's a Swiss Army data platform. Here's why I switched and never looked back.

postgresqlpostgresdatabase +4
Read more
🔧 Engineering

SQLite: The Powerhouse Hiding in Plain Sight

I dismissed SQLite as a 'toy database' for years. No server, no configuration, just a file. Then I learned that it runs on every smartphone, every browser, every Mac, every Python install, and handles more read queries per day than all other databases combined. I was very, very wrong about SQLite.

sqlitedatabasesql +5
Read more
⚙️ Backend

MyBatis: Finally Talking to a Database

Goodbye in-memory ArrayList, hello real database. Learn to connect Spring Boot to MySQL using MyBatis, write SQL mappers, handle transactions, and stop losing data every time you restart the server.

javaspring-bootmybatis +6
Read more
🔧 Engineering

MySQL: My First Real Database

Before I understood databases, I stored everything in JSON files and localStorage. Then I discovered MySQL, and suddenly data had structure, relationships, and rules. Here's how I went from 'what's a JOIN?' to actually building things that persist.

mysqldatabasesql +4
Read more
4 posts tagged "sql"
Saurav.dev

© 2026 Saurav Sitaula.AstroNeoBrutalism