I’m thrilled to announce the release of Qiu – a no-nonsense SQL query runner designed to make raw SQL fun again. Let’s be honest, ORMs have their place, but they can get a bit overwhelming when all you want is to write simple SQL. I’ve always enjoyed crafting raw SQL queries, but I realized that I needed practice — a lot of it. That’s where Qiu comes in.
With Qiu, there’s no more wrestling with bulky ORMs or getting lost in layers of abstraction. It’s a lightweight tool designed for developers who, like me, want to focus on mastering SQL without the extra noise. Writing raw SQL should be empowering, not a chore, and Qiu makes that happen.
Why Qiu?
I created Qiu because I wanted a simple yet powerful way to run raw SQL queries, practice them, and avoid the typical hassles of ORMs. Whether you’re a database newbie looking to sharpen your SQL skills or a seasoned developer who prefers simplicity over abstraction, Qiu has got you covered.
Features
Direct SQL Execution: Forget the layers of ORM and run your raw SQL queries directly.
Database Support: Currently supports PostgreSQL, MySQL, and MariaDB.
Efficient Task Queue: Queue your SQL commands for smooth execution without clogging up your system.
Rate Limiting: Built-in rate limiter to handle your query execution safely and efficiently.
File Support: Execute queries directly from .sql files.
How to Install
Getting started with Qiu is as easy as:
Usage Example
Here’s how Qiu works in action:
const db = new Qiu(‘mysql‘, ‘-u username -ppassword‘);
// Before that, you have to create the database Like: CREATE DATABASE db
db.use(‘my_database‘);
// Running a raw query
await db.exec(‘SELECT * FROM users;‘);
// Running a query from an SQL file
await db.exec(‘./queries/create_table.sql‘);
Why You’ll Love Qiu:
No ORM Frustrations: Sometimes, ORMs add unnecessary complexity. With Qiu, you can focus purely on your SQL.
Simple & Lightweight: Perfect for projects where you just need to run raw queries without the heavy baggage.
Practice SQL Efficiently: Ideal for honing your raw SQL skills and getting hands-on practice.
Conclusion
Qiu was born from my desire to get better at SQL and enjoy the process without the distractions of ORMs. If you’re tired of heavy abstractions and just want a straightforward SQL runner, give Qiu a try!
Explore more on the GitHub repository or npm package page.