Introducing Qiu!

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.

The above is the detailed content of Introducing Qiu!. For more information, please follow other related articles on the PHP Chinese website!