Introducing Qiu!

I’m thrilled to announce the release ofQiu– 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 whereQiucomes in.

WithQiu, 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, andQiumakes that happen.

WhyQiu?

I createdQiubecause 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,Qiuhas 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 withQiuis as easy as:

npm install @medishn/gland-qiu

Usage Example

Here’s howQiuworks 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 LoveQiu:

• 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

Qiuwas 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, giveQiua 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!