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!

Detailed explanation of JavaScript string replacement method and FAQ This article will explore two ways to replace string characters in JavaScript: internal JavaScript code and internal HTML for web pages. Replace string inside JavaScript code The most direct way is to use the replace() method: str = str.replace("find","replace"); This method replaces only the first match. To replace all matches, use a regular expression and add the global flag g: str = str.replace(/fi

This tutorial shows you how to integrate a custom Google Search API into your blog or website, offering a more refined search experience than standard WordPress theme search functions. It's surprisingly easy! You'll be able to restrict searches to y

So here you are, ready to learn all about this thing called AJAX. But, what exactly is it? The term AJAX refers to a loose grouping of technologies that are used to create dynamic, interactive web content. The term AJAX, originally coined by Jesse J

This article series was rewritten in mid 2017 with up-to-date information and fresh examples. In this JSON example, we will look at how we can store simple values in a file using JSON format. Using the key-value pair notation, we can store any kind

Leverage jQuery for Effortless Web Page Layouts: 8 Essential Plugins jQuery simplifies web page layout significantly. This article highlights eight powerful jQuery plugins that streamline the process, particularly useful for manual website creation

Core points This in JavaScript usually refers to an object that "owns" the method, but it depends on how the function is called. When there is no current object, this refers to the global object. In a web browser, it is represented by window. When calling a function, this maintains the global object; but when calling an object constructor or any of its methods, this refers to an instance of the object. You can change the context of this using methods such as call(), apply(), and bind(). These methods call the function using the given this value and parameters. JavaScript is an excellent programming language. A few years ago, this sentence was

jQuery is a great JavaScript framework. However, as with any library, sometimes it’s necessary to get under the hood to discover what’s going on. Perhaps it’s because you’re tracing a bug or are just curious about how jQuery achieves a particular UI

This post compiles helpful cheat sheets, reference guides, quick recipes, and code snippets for Android, Blackberry, and iPhone app development. No developer should be without them! Touch Gesture Reference Guide (PDF) A valuable resource for desig


Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

AI Hentai Generator
Generate AI Hentai for free.

Hot Article

Hot Tools

SAP NetWeaver Server Adapter for Eclipse
Integrate Eclipse with SAP NetWeaver application server.

EditPlus Chinese cracked version
Small size, syntax highlighting, does not support code prompt function

Dreamweaver Mac version
Visual web development tools

Notepad++7.3.1
Easy-to-use and free code editor

VSCode Windows 64-bit Download
A free and powerful IDE editor launched by Microsoft
