SQLite interface(s) for creating complex queries with a table that has 68 million rows?

This page summarizes the projects mentioned and recommended in the original post on /r/sqlite

Our great sponsors
  • SonarLint - Clean code begins in your IDE with SonarLint
  • InfluxDB - Collect and Analyze Billions of Data Points in Real Time
  • Mergify - Updating dependencies is time-consuming.
  • sqlitestudio

    A free, open source, multi-platform SQLite database manager.

    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.

  • sqlitebrowser

    Official home of the DB Browser for SQLite (DB4S) project. Previously known as "SQLite Database Browser" and "Database Browser for SQLite". Website at:

    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.

  • SonarLint

    Clean code begins in your IDE with SonarLint. Up your coding game and discover issues early. SonarLint is a free plugin that helps you find & fix bugs and security issues from the moment you start writing code. Install from your favorite IDE marketplace today.

  • sqlite-gui

    Lightweight SQLite editor for Windows

    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.

  • visidata

    A terminal spreadsheet multitool for discovering and arranging data

    You can try Visidata

NOTE: The number of mentions on this list indicates mentions on common posts plus user suggested alternatives. Hence, a higher number means a more popular project.

Suggest a related project

Related posts