Grow your community and let your products shine!
Register | Login
Menu
Zero Configuration
SQLite does not require any server setup or configuration, allowing for easy integration and deployment in applications.
Lightweight
It is extremely lightweight, with a small footprint, making it ideal for embedded systems and mobile applications.
Self-Contained
SQLite is self-contained, meaning it has minimal external dependencies, which simplifies its distribution and usage.
File-Based Storage
Data is stored in a single file, which makes it easy to manage and transfer databases as simple files.
ACID Compliance
SQLite supports Atomicity, Consistency, Isolation, and Durability (ACID) properties, ensuring reliable transactions.
Cross-Platform
SQLite is available on numerous platforms, including Windows, MacOS, Linux, iOS, and Android, providing a broad compatibility range.
Public Domain
SQLite operates under the public domain, allowing for unrestricted use in commercial and non-commercial applications.
Yes. A Lightroom catalog file is, after all, just a SQLite database. (Srsly, make a copy of your catalog file, rename it whatever.sqlite and use your favorite SQLite GUI to rip it open and look at the tables and fields). It’s just storing the pathame to the RAW file for that file’s record in the database.
Source:
over 1 year ago
I use visidata with a playback script I recorded to open the sheet to a specific Excel tab, add a column, save the sheet as a csv file. Then I have a sqlite script that takes the csv file and puts it in a database, partitioned by monthYear.
Source:
over 1 year ago
Use the most-used database in the world: https://sqlite.org/index.html.
Source:
over 1 year ago
With this in mind, I wrote a few versions of this post, but I hated them all. Then I realized that jodliterate PDF documents mostly do what I want. So, instead of rewriting MirrorXref.pdf, I will make a few comments about jodliterate group documents in general. If you’re interested in using SQLite with J, download the self-contained GitHub files MirrorXref.ijs and MirrorXref.pdf and have a look.
– Source: dev.to
/
about 2 years ago
SQLite, by many estimates, is the most widely deployed SQL database system on Earth. It’s everywhere. It’s in your phone, your laptop, your cameras, your car, your cloud, and your breakfast cereal. SQLite‘s global triumph is a gratifying testament to the virtues of technical excellence and the philosophy of “less is more.”.
– Source: dev.to
/
about 2 years ago
But you could also look at something like sqlite (https://sqlite.org/index.html), a super simple SQL database that’s quite powerful, and easy to use.
Source:
about 2 years ago
It would be one thing if he just put the project out there for other people to use. SQLite for example does that, the project does not accept contributions. But the moment you accept contribution you also agree to share copyright. You cannot just grab other people’s work and run with it.
Source:
over 2 years ago
It’s that file indeed. It’s a sqlite database, so you’ll need to edit it via SQL and the sqlite CLI (or a suitable GUI).
Source:
over 2 years ago
Flask is a framework for building web applications utilizing Python and SQLite with sqlalchemy is a database engine that can be used to store application data.
– Source: dev.to
/
almost 3 years ago
I started using Fossil for my new projects this year, mostly just to try something new, but it’s really nice. It is simpler than git and comes with a built-in web-GUI for tracking issues and a built-in wiki and ways to publish files. It is made by the people behind Sqlite and it is what you see on https://sqlite.org/index.html (and on https://www.fossil-scm.org/). It is made for small teams working on small…
Source:
almost 3 years ago
You have to save that data, a database like sqlite, or using sed to edit a static file.
Source:
almost 3 years ago
I’d recommend SQL since it tends to be used by other languages for DB support. You can read and download a standalone SQL version from sqlite.org.
Source:
about 3 years ago
This is by design and a good thing. You can learn SQLite at https://sqlite.org/index.html. They have excellent documentation.
Source:
about 3 years ago
This tutorial will guide us through building an interactive CLI app with Go, Cobra and promptui. We will learn how to prompt the user for input data and persist this data to an SQLite database. Unlike the previous app we built, this experience will feel more like a two way conversation.
– Source: dev.to
/
about 3 years ago
If the exact implementation of the SQL server doesn’t matter, I might suggest postgresql or sqlite. Both are free, widely used and very solid. There are also gui tools like pgadmin4 . They both have plugin ecosystems if you want to experiment with NoSQL (storing JSON and other weird stuff for a relational db).
Source:
over 3 years ago
SQLite is used everywhere and it’s super simple for your use case, since there is no server to manage or user admin things to be concerned about.
Https://sqlite.org/index.html.
Source:
over 3 years ago
You can look at Fossil for instance, the version management tool that they developed for developing Sqlite. It is a small C application that stores data in, of course, Sqlite. There is a live public instance here for instance: https://sqlite.org/index.html (and one at https://fossil-scm.org).
Source:
over 3 years ago
For a local database, SQLite is likely your best option.
Source:
over 3 years ago
