sqlite-gui
datasette
Our great sponsors
sqlite-gui | datasette | |
---|---|---|
26 | 185 | |
1,035 | 8,791 | |
- | - | |
4.2 | 9.2 | |
22 days ago | 8 days ago | |
C | Python | |
GNU General Public License v3.0 only | Apache License 2.0 |
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.
sqlite-gui
-
C# program not able to open or connect to an encrypted SQLite Database
DB4S provides only one algorithm based on official SQLite cipher. You can encrypt your database with another in SQLiteStudio or sqlite-gui (I'm an author). Both applications use SQLite3 Multiple Ciphers-library.
- SQLite is not a toy database
- Lightweight SQLite Editor for Windows
-
SQLite interface(s) for creating complex queries with a table that has 68 million rows?
The most popular apps areDB4S and SQLiteStudio. If you are planning to run long time queries, then you might encounter with problems by running them in parallel in these tools. To run several queries in a real parallel mode you can use Navicat for SQLite or my sqlite-gui.
-
sqlite-x: The simplest editor for Windows
For advanced users I recommend to check another my app - sqlite-gui.
-
SQLite GUI
SQLite-GUI from GitHub
This is what you want: https://github.com/little-brother/sqlite-gui
-
Sensitive data
Popular SQLite editors e.g. DB4S (supports only SQL Cipher) and SQLiteStudio (SQLCipher and perhaps anothers via plugin) can work with encrypted databases. My sqlite-gui support 5 ciphers through SQLite3 Multiple Ciphers.
-
Why SQLite may become foundational for digital progress
I've tried over 15 sqlite management tool, but SqliteStudio is my favorite! And recently discovered https://github.com/little-brother/sqlite-gui
datasette
-
LaTeX and Neovim for technical note-taking
I use Anki the exact same way. After a lifetime of learning I have accepted that I will never read over anything I write for myself voluntarily - so my two options are:
1. Write an article so good I can publish it and look it over myself later on. I did this last year with https://andrew-quinn.me/fzf/, for example.
2. Create Anki cards out of the material. Use the builtin Card Browser or even https://datasette.io/ on the underlying SQLite database in a pinch to search for my notes any time I have to.
-
Daily Price Tracking for Trader Joes
Were you aware of, or tempted by https://datasette.io/ for creating your solution?
-
SQLite-Web: Web-based SQLite database browser written in Python
Datasette [0] is worth mentioning in this context since I didn't know about it until the second half of last year.
-
Ask HN: What two software products should have a kid?
Browsing HN, GitHub and the like we get to see a huge variety of software products and code bases.
I often see products and think - if this product X, got together with Y, it would be pretty cool - kind of like if they had a kid together.
Not too literally, but more on the conceptual level - my level of programming is low.
E.g. Just some....
- pocketable.io & datasette (+with some more charting) [https://pocketbase.io, https://datasette.io]
-
Ask HN: Looking for a project to volunteer on? (February 2024)
You might like the Datasette project: https://datasette.io/
I don't think they are desperate for contributions but it's a welcoming environment and a fun project to hack on. You'll learn a lot just from reading the source and the incredibly informative PRs. The creator is a really talented developer with a great blog which shows up on the HN front page often.
-
Stuff I Learned during Hanukkah of Data 2023
Last year I worked through the challenges using VisiData, Datasette, and Pandas. I walked through my thought process and solutions in a series of posts.
-
Ask HN: What are some unpopular technologies you wish people knew more about?
Don't overlook https://datasette.io/ even though it does much more than endpoints.
- Effective GPT-4 Programming
-
What is Glamorous Toolkit v1.0?
OK, having watched the video at https://www.youtube.com/watch?v=lqogvp1dGpk (8 minutes, so 4 minutes if you 2x it) I understand why they have such a hard time answering the question "What is Glamorous Toolkit?"
It's effectively a combination of a Smalltalk IDE, a Jupyter/Observable-style notebook environment and a tool somewhat like R Studio.
It's a hard thing to categorize, because it's not exactly the same kind of thing as anything else.
I emphasize wit the challenge: I have a similar problem with my https://datasette.io/ project.
What are some alternatives?
nocodb - 🔥 🔥 🔥 Open Source Airtable Alternative
duckdb - DuckDB is an in-process SQL OLAP Database Management System
sqlitestudio - A free, open source, multi-platform SQLite database manager.
sql.js-httpvfs - Hosting read-only SQLite databases on static file hosters like Github Pages
litestream - Streaming replication for SQLite.
Sequel-Ace - MySQL/MariaDB database management for macOS
beekeeper-studio - Modern and easy to use SQL client for MySQL, Postgres, SQLite, SQL Server, and more. Linux, MacOS, and Windows.
Redash - Make Your Company Data Driven. Connect to any data source, easily visualize, dashboard and share your data.
gomodest - A complex SAAS starter kit using Go, the html/template package, and sprinkles of javascript.
roapi - Create full-fledged APIs for slowly moving datasets without writing a single line of code.
dbhub.io - A "Cloud" for SQLite databases. Collaborative development for your data. 😊
Inja - A Template Engine for Modern C++