SQLite Reviews and details

Social recommendations and mentions

• Can I have my Lightroom catalogue pointing at two sources...?

  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: 11 months ago

• Building a database to search Excel files

  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: about 1 year ago

• Saw this on my friends Snapchat story, this hurts my heart

  Use the most-used database in the world: https://sqlite.org/index.html. Source: about 1 year ago

• "Managing" a SQLite Database with J (Part 2)

  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 / over 1 year ago

• "Managing" a SQLite Database with J (Part 1)

  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 / over 1 year ago

• OffMyExcelChest: People who inherited a spreadsheet but are unwilling to improve it

  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: almost 2 years ago

• chore(license): use Anti 996 license · neoclide/coc.nvim@6d4a2a3

  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: about 2 years ago

• History file

  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

• Seven URL Shortener

  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 / over 2 years ago

• Tips for solo game developers.

  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: over 2 years ago

• I want to build something that shows my class averages and constantly updates.

  You have to save that data, a database like sqlite, or using sed to edit a static file. Source: over 2 years ago

• Best language to learn in 2weeks

  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: over 2 years ago

• Validation question and a rant

  This is by design and a good thing. You can learn SQLite at https://sqlite.org/index.html. They have excellent documentation. Source: over 2 years ago

• Building an interactive CLI app with Go, Cobra & promptui

  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 / almost 3 years ago

• Home SQL Server

  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: almost 3 years ago

• Struggling with actually using SQL in daily work

  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: almost 3 years ago

• Simple reddit-like CRUD website written in C

  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: about 3 years ago

• Saving user inputs

  For a local database, SQLite is likely your best option. Source: about 3 years ago