![]() In addition to SQL, CSV, JSON exports, it also exports data to LaTeX, Wiki Mark, and PHP Array.HeidiSQL comes with all the handful of SQL features any developer needs, like SQL Query editor, SSH Tunel connection, variables editor, table editor, trigger editor, and large file support.īeyond its rich features set, which may look similar to other software packages on this list, it has many unique features which are: HeidiSQL is a free SQL manager for SQL databases as MySQL, MariaDB, SQLite, PostgreSQL, and Microsoft SQL database. If you prefer the terminal app, you need to install it through NPM. You can obtain Sqlectron for Windows, Linux, and macOS. Sqlectron supports SSL connection and comes with table views, SQL query manager, full-text search option, and SQL auto-complete feature. It also offers seamless support for Cassandra DB which is a NoSQL database. Sqlectron supports several SQL database engines out-of-the box-like PostgreSQL, Redshift, MySQL, MariaDB, Microsoft SQL Server, and SQLite. It comes in two editions: the GUI mode and the terminal app which you can run from your terminal. Sqlectron is an Electron-based, free, open-source SQL editor for various desktops. It also offers a self-hosted web-based edition which you can install on your local or remote server. Offers table structure viewer, configurable shortcuts, and dark themeĭbGate is available for Windows, Linux, and macOS.Rich database design tools and schema editor.Export data to SQL, CSV, JSON, or Excel files.Comes with SQL query auto-complete suggestion.Query editor, query designer, and SQL generator.2- DbGateĭbGate is a free, modular, open-source multi-platform SQL manager, which supports traditional SQL databases and NoSQL databases like MongoDB.ĭbGate comes with dozens of features that make managing multiple databases is a piece of cake. Allows exporting data to many formats (SQL, JSON, JSONL, CSV).īeekeeper Studio is available for Windows as an installable package and portable edition, Linux, and macOS.SSL connection support or through SSH tunnels.It comes packed with developer-friendly features to boost productivity and efficiency.īeekeeper Studio supports several SQL database engines as PostgreSQL, MySQL, SQLite, Redshift, SQL Server, CockroachDB, and MariaDB. 1- Beekepperīeekeeper Studio is one of the most popular SQL managers and database clients among developers. All rights reserved.In this article, we offer you a list of open-source, free SQL clients for developers. The MIT License © 2020-present Kriasoft / Theo Gravity. Using SQLite with Node.js for Rapid Prototyping on.If you know of any others, feel free to open a PR to add them to the list. Should be mostly compatible with this library. sqlite3-offline-next: Offers pre-compiled sqlite3īinaries if your machine cannot compile it.sql.js: SQLite compiled to Webassembly.Bun sqlite3: bun:sqlite is a high-performance builtin SQLite3 module for bun.js.better-sqlite3: Totes itself as the fastest and.You might want to try these other SQLite libraries: This library and the library it primarily supports, sqlite3, may not be the best library thatįits your use-case. DBeaver: Full-featured multi-platform database tool and designer.HeidiSQL: Full-featured database editor.SQLite Studio: A free, open source, multi-platform SQLite database manager written in C++, with use of Qt framework.Starts up a server that provides a web interface to your SQLite data. datasette: Datasette is a tool for exploring and publishingĭata.DB Browser for SQLite: Desktop-based browser.Beekeeper Studio: Open Source SQL Editor and Database Manager.See the docs directory for full documentation. db is an instance of `sqlite#Database` // which is a wrapper around `sqlite3#Database` const db = await open ( ) API Documentation $ npm install sqlite3 -save Install sqlite ![]() Most people who use this library will use sqlite3Īny library that conforms to the sqlite3 ( API) Use generics to get better typings on your rows.Specify typings for a specific database driver.Note v4 of sqlite has breaking changes compared to v3! Please see CHANGELOG.md for more details. A wrapper library written in Typescript with ZERO dependencies that adds ES6 promisesĪnd SQL-based migrations API to sqlite3 ( docs).
0 Comments
Leave a Reply. |