aiosqlite
sqllex
Our great sponsors
| aiosqlite | sqllex | |
|---|---|---|
| 6 | 16 | |
| 1,071 | 88 | |
| 4.0% | - | |
| 7.3 | 0.0 | |
| 23 days ago | almost 2 years ago | |
| Python | Python | |
| MIT License | GNU General Public License v3.0 only |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
aiosqlite
- Roast my repository!
-
Using GraphQL with Strawberry, FastAPI, and Next.js
Aiosqlite — This provides async support for SQLite
-
Is there going to be any difference with temp files?
I access a local database concurrently with this sqlite wrapper but a problem has risen, I want to cache some data IN THE BACKEND but the only solution that I could think of is a in-memory database with shared cache but I think It would be impossible to maintain active since It has to have a conection active all the time in the backend. I came to the conclusion that It is better to use this approach in a separated thread in the front end with pyqt.
-
Getting started with GraphQL in Python with FastAPI and Ariadne
aiosqlite: A friendly, async interface to sqlite databases.
-
Hosting and DataBase
You should use any database with support for async. The people who created and maintain Discord.py suggest using an async branch of SQLite3 called aiosqlite.
-
Sending a message to extracted SQLite variable as a channel?
As a side note, you should use the async version of SQLite, aiosqlite.
sqllex
-
ORM for beginners | SQLite + sqllex
P.S.:Here is few useful links: — Sqllex ORM (github page) — Sqllex docs — Project showcase — Another example #0 — Another example #1
-
Any alternatives to SQLAlchemy Core for a "query builder" library?
FYI: If you're looking for something with more than one user, take a look at sqllex, which is a great query builder along the same lines. I made HissDB because sqllex didn't parameterize its queries, but I believe they've fixed that issue since then.
-
Finally release v0.2.0.0 (sqllex)
Sqllex it's nice Python ORM available for SQLite and PostgreSQL. I have made many examples and posts about this. So let me know what you think about this project.
-
FINALLY v0.2.0.0 RELEASE!
Just released SQLLEX v0.2.0.0 after 2 months of preparing. Sqllex it's ORM for SQLite and (by now) PostgreSQL. I made many examples and posts about it. And I'll be happy if you'll try it by yourself in your projects.
-
SQLLEX ORM | How to use SQLite without SQL
"SQLLEX | Awesome example #1"
How I got later, this technology calls ORM (Object-Relational Mapping) and I'm not the first one who create something like this. But in my opinion, SQLLEX is the most intuitive ORM I'v ever seen and I'm interested what do you think. Check this out.
-
How to auto-doc your project?
Last few months I'm working on my biggest project Sqllex. All this time I have been using the wiki tab (on github) to document the project. But this project is getting so big that it gets really difficult.
-
Best Python course for beginners
Sqllex - just a nice tool for comfortable and safe working with SQLite databases.
-
How reddit bring developers together | SQLLEX
Sqllex package has been downloaded from pypi.org over 550 times, github repo got 45 new stars.
- SQLLEX is promoting your projects
What are some alternatives?
Librarian - Your minimalistic helper to find what you have written and forgot. It uses Sqlite FTS5 with Snowball tokenizer supporting different languages.
PyPika - PyPika is a python SQL query builder that exposes the full richness of the SQL language using a syntax that reflects the resulting query. PyPika excels at all sorts of SQL queries but is especially useful for data analysis.
FastQL - ⚙️ Full stack, Modern Web Application Generator. ✨ Using FastAPI, GraphQL, PostgreSQL as database, Docker, automatic HTTPS and more. 🔖
jaydebeapi - JayDeBeApi module allows you to connect from Python code to databases using Java JDBC. It provides a Python DB-API v2.0 to that database.
fastapi - FastAPI framework, high performance, easy to learn, fast to code, ready for production
Python PG Extras - Python PostgreSQL database performance insights. Locks, index usage, buffer cache hit ratios, vacuum stats and more.
speed-camera - A Unix, Windows, Raspberry Pi Object Speed Camera using python, opencv, video streaming, motion tracking. Includes a Standalone Web Server Interface, Image Search using opencv template match and a whiptail Admin Menu Interface Includes picam and webcam Plugins for motion track security camera configuration including rclone sync script. watch-app allows remotely controller camera configuration from a remote storage service name. Uses sqlite3 and gnuplot for reporting. Recently added openalpr license plate reader support.
rgpocode - A Python script of a sqlite3 based reverse geocoder using postal codes
sqlalchemy-strawberry-fastapi-nextjs
pangres - SQL upsert using pandas DataFrames for PostgreSQL, SQlite and MySQL with extra features
Automatic_Zoom_Meeting_Joiner - A well documented Python Graphical User Interface (GUI) program to automatically join zoom meetings. Most usefull for those, who have to join multiple meetings in a day and have different credentials for each meeting
FrameRecorder - Imagine you are drawing pictures or writing a program on your computer. Wouldn't you like to shoot small clips of your work while doing this? That's when Frame Recorder comes to your aid. It will save it for you! See hours of process in just a few minutes!