Introducing Qiu!

RMAG news

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:

npm install @medishn/gland-qiu

Usage Example

Here’s how Qiu works in action:

import { Qiu } from @medishn/gland-qiu;

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.

Please follow and like us:
Pin Share