|5 months ago||4 days ago|
|GNU General Public License v3.0 only||GNU General Public License v3.0 or later|
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.
ORM for beginners | SQLite + sqllex
2 projects | reddit.com/r/Python | 13 Mar 2022
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?
2 projects | reddit.com/r/Python | 19 Dec 2021
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.
Sunday Daily Thread: What's everyone working on this week?
2 projects | reddit.com/r/Python | 22 May 2021
Whole this week I working on my biggest project SQLLEX - it's python package for more comfortable interacting with databases. It got 7 new releases on this week (v0.1.8.5-0.1.5.12), 5 of which were about bug fixes. But two other were about major updates of code structure, adding new fetches and syntax sugar. Now you can just take your table as specific object or got column of table just by _getitem_ method:
SQLLEX | Better than sqlite3
2 projects | reddit.com/r/Python | 13 May 2021
Github repo: https://github.com/v1a0/sqllex
Between using H2 and HSQLDB as a production DB, which is the better choice?
3 projects | reddit.com/r/java | 25 Oct 2022
I've used all H2, hsqldb and SQLite. For a desktop app you want SQLite, as it is explicitly designed for this scenario. One nice bonus is that there are a TON of apps and utilities that work with SQLite files directly, making it very easy to work with.
TIL that scientists had to rename genes because MS Excel would convert those names into dates
For his use case microsoft access, libre office base, and https://sqlitebrowser.org/ make more sense
microsoft access, libre office base, or even sqlite browser https://sqlitebrowser.org/ (which I prefer, as it is a real database)
This collecting personal data?
2 projects | reddit.com/r/Database | 18 Oct 2022
Download an SQLite client and check e.g. https://sqlitebrowser.org/
6 projects | reddit.com/r/sqlite | 27 Sep 2022
https://sqlitebrowser.org/ is about the most standard, however I also really like to use DBeaver as it is available on all my platforms (macOS, Linux, and Windows) and covers just about any DB platform you can think of - the Community version is free and awesome, no nagging to upgrade to the commercial version and honestly I've never really had the need for the commercial version: https://dbeaver.io/6 projects | reddit.com/r/sqlite | 27 Sep 2022
I use it in Tkinter programs - https://sqlitebrowser.org
Any MS dll and/or sq3 experts hanging around?
2 projects | reddit.com/r/raleigh | 24 Sep 2022
So, try using a tool that can read SQLite databases, like https://inloop.github.io/sqlite-viewer/ or https://sqlitebrowser.org/
Looking For Personal Database
4 projects | reddit.com/r/opensource | 22 Sep 2022
I made a terminal-based flashcard-app written in rust, featuring knowledge-dependency logic
2 projects | reddit.com/r/commandline | 19 Sep 2022
Like how the cards are saved? If you download sqlitebrowser you can inspect the database.
What are some alternatives?
sqlitestudio - A free, open source, multi-platform SQLite database manager.
sqlcipher - SQLCipher is a standalone fork of SQLite that adds 256 bit AES encryption of database files and other security features.
nocodb - 🔥 🔥 🔥 Open Source Airtable Alternative
beekeeper-studio - Modern and easy to use SQL client for MySQL, Postgres, SQLite, SQL Server, and more. Linux, MacOS, and Windows.
godot-sqlite - GDNative wrapper for SQLite (Godot 3.2+)
dbhub.io - A "Cloud" for SQLite databases. Collaborative development for your data. :)
Sequel-Ace - MySQL/MariaDB database management for macOS
Sequelize - Feature-rich ORM for modern Node.js and TypeScript, it supports PostgreSQL (with JSON and JSONB support), MySQL, MariaDB, SQLite, MS SQL Server, Snowflake, Oracle DB (v6), DB2 and DB2 for IBM i.
Magisk - The Magic Mask for Android
rqlite - The lightweight, distributed relational database built on SQLite
Tautulli - A Python based monitoring and tracking tool for Plex Media Server.
Cryptomator - Multi-platform transparent client-side encryption of your files in the cloud