SQLite Reviews

DBeaver Reviews

SQLite mentions (18)

• 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: about 1 year 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: over 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 / almost 2 years 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 / almost 2 years ago

DBeaver mentions (95)

• From GUI to CLI: Transforming my query workflow with usql and jq

  I usually deal with data spread across multiple databases and my tool for the job of inspecting resources and test some simple queries was dbeaver, which is great, but it can be overwhelming in terms of visual information (specially on my use case). I needed speed, I needed something in the terminal, I needed vim. - Source: dev.to / about 1 month ago

• Essential Tools & Technologies for New Developers

  Now that we've talked about databases, we are going to look at some software for connecting and managing your databases. DBeaver is a good free software that works on all platforms. But for those who are using JetBrains, you can also use Datagrip. - Source: dev.to / 26 days ago

• I Deployed My Own Cute Lil’ Private Internet (a.k.a. VPC)

  It’s cool to show a demo and talk about the infrastructure with cute diagrams, but I always want to prove, even if just to myself, that things work as expected. So I thought a good way to test it would be to try connecting directly to both databases using my database client, DBeaver. - Source: dev.to / 3 months ago

• DBeaver – open-source Database client

  List of db clients I have bookmarked https://dbeaver.io/. - Source: Hacker News / 3 months ago

• 15 open-source tools to elevate your software design workflow

  As a great alternative to DBeaver, DBGate provides a variety of tools to manage your databases. Besides in built-in support charts and a query builder, you can use Javascript to query data. It even supports NoSQL drivers and native script builders. Give it a try if your project demands simplicity over in-depth features for SQL databases. - Source: dev.to / 4 months ago