Hot answers tagged

16 votes

Is there a software tool which allows to perform SQL on CSV files?

Have a look at q q is a command line tool that allows direct execution of SQL-like queries on CSVs/TSVs (and any other tabular text files). https://github.com/harelba/q
Benjamin Crouzier's user avatar
9 votes

Is there a software tool which allows to perform SQL on CSV files?

The 'problem' with a CSV file is that the single 'table' doesn't have a name. Therefore, you'll need to define a table (including columns) and import the CSV file before doing any SQL queries on it. ...
Glorfindel's user avatar
  • 2,005
5 votes
Accepted

SQL table handler without server/client

SQLite might fit your requirements. It is an SQL database system that uses simple files as databases that are accessed without a client/server mechanism, just via the API of a library. A command-line ...
O. R. Mapper's user avatar
5 votes
Accepted

Is there a lightweight SQL-capable database management software that doesn't try to be a server?

Sounds like Sqlite would be just the thing. Sqlite comes as a C library and command-line utility that executes SQL statements against a database file. The software intelligently cootdinates multiple ...
Ari Fordsham's user avatar
4 votes

Is there a software tool which allows to perform SQL on CSV files?

If you have the flexibility to use some light scripting languages try - R script - It has sqldf library which can be used to run sql queries on dataframes. You just have to read your csv into a ...
skybunk's user avatar
  • 141
4 votes

Is there a software tool which allows to perform SQL on CSV files?

Try csvsql. It is part of csvsuite, a suite of command line tools written in python, since March 2019 tested against Python 3.7. The csvkit tools are described in the book Data Science at the ...
knb's user avatar
  • 2,864
4 votes

Is there a software tool which allows to perform SQL on CSV files?

Using PostgreSQL and DBeaver is another option. PostgreSQL is a sophisticated, open source database system. It allows for importing CSV files through the COPY command and through graphical UIs such as ...
Lars Helge Øverland's user avatar
3 votes

Tool to compare the results of an SQL query on two databases

There is a tool called SelectCompare that allows you to compare two queries. SelectCompare allows to create comparison projects, which define queries against any two data sources that can be ...
db toro's user avatar
  • 41
3 votes

Object-Oriented SQL Representation

I can recommend SqlKata for this purpose. It's a .NET library that helps in building SQL queries for different DB engines and optionally to execute them, by using a similar syntax to what you posted. ...
Alejandro's user avatar
  • 741
3 votes

Is there a software tool which allows to perform SQL on CSV files?

SQLite is a nice lightweight tool that is supported by multiple languages. If you use Python, there are several tools in the Python Package Index (pypi.org) that make it easy to use (including https:/...
rd_nielsen's user avatar
3 votes

Is there a software tool which allows to perform SQL on CSV files?

Try RBQL - it provides SQL-like dialect with Python or Javascript expressions. You can use RBQL from the command line (RBQL in pip) And from Rainbow CSV text editor extensions which provide nice GUI ...
user150547's user avatar
3 votes

Is there a software tool which allows to perform SQL on CSV files?

I know I'm late to the party, but I've created a Desktop app that can perform SQL on a bunch of CSV files. It is a Desktop app because it can easily handle a 600MB CSV file (only taking ~15 seconds to ...
Tanin's user avatar
  • 131
3 votes
Accepted

Alternative to SQL Server Management Studio for Ubuntu

Azure Data Studio from Microsoft should be an easy start for previous SSMS users.
Ross Presser's user avatar
3 votes
Accepted

Command line SQL formatter or beautifier

Prettier integrates with editors and Git, has a command-line interface, and a SQL plugin.
mustaccio's user avatar
  • 196
2 votes
Accepted

What is the best frontend program for my database needs?

FileMaker FileMaker is a relational database client server database that run on Mac, Windows, iOS, and web. It combines a database server with a form-building tool and a proprietary programming ...
Basil Bourque's user avatar
2 votes

Tool to compare the results of an SQL query on two databases

This tool called "JuxtAPPose" does pretty much does what you mention: Compare query results (can connect to DBs) Can load files instead of a query (e.g. you are validating a report) Costs less than $...
Randy's user avatar
  • 31
2 votes

Graphical SQL client

I'd recommend checking out MySQL Workbench. It's free and runs on Windows 10. It'll let you connect to multiple DBs and save your login passwords among other things.
Russ L's user avatar
  • 186
2 votes

What gui(RDBMS) to use for MariaDB on Linux?

I use MariaDB on Arch Linux as well and I can recommend DBeaver. Free Universal Database Tool https://dbeaver.io/ Free multi-platform database tool for developers, SQL programmers, database ...
MountainX's user avatar
  • 160
2 votes
Accepted

Check for duplicate column names in an SQL query

No software needed. Create a dummy view using your query. If it works, you're good, because views don't support multiple columns with the same name. CREATE VIEW v1 AS SELECT ... ...your query. If ...
Michael - sqlbot's user avatar
2 votes

Is there alternative to SQL Developer that supports PL/SQL too?

Eclipse has various plugins, capable to develop Pl/SQL scripts, too. Oracle SQL Developer uses an eclipse3 core, this is why it is not the best.
peterh's user avatar
  • 782
2 votes

Test data generator for MySQL

I've seen this question before https://stackoverflow.com/questions/15608438/how-can-i-populate-my-databases-all-tables-with-random-data! I found that filldb.info seems to works well. Main Database ...
François's user avatar
2 votes
Accepted

Faster alternative to Microsoft Access for simple ad-hoc queries

As you just confirmed, SQLiteStudio is what you're looking for: it works with local database files, which are "portable" (you can just copy them to another machine, and even use them with other ...
Izzy's user avatar
  • 18.7k
2 votes

What is the best spreadsheet-like tool to manage structured data with tags and multiple columns of different sizes

A form in LibreOffice Base can ensure data consistency. However, doing everything you described in Base requires careful design and likely some macro programming. As stated in the comments, Calc can ...
Jim K's user avatar
  • 121
2 votes

What DB engine should be used for a petabyte database?

Take a look at CockroachDB. You're talking big data and the platform needs to support serious scaling. https://www.cockroachlabs.com/ It's probably good out of the box and it has a good open source ...
NothingToSeeHere's user avatar
2 votes

How do I store/share data between different devices?

MySQL allows multiple processes to access the database simultaneously, but processes may lock tables so that other processes can't access them. Your problem with multiple client connections may have ...
rd_nielsen's user avatar
2 votes

Is there a software tool which allows to perform SQL on CSV files?

Flatbase is a free web app that allows you to query CSV, JSON, and other flat files using SQL. You can also graph results and share with colleagues.
mockaroodev's user avatar
2 votes

Open Source Knowledge Site

I've used DokuWiki which is simpler than other wiki systems. No database need and has a very nice set of plugins for extending. Implies you learn the syntax, but allows for what you're looking for. ...
Juanga Covas's user avatar
2 votes

open source tool for SQL Queries

Pretty much any maintained open-source SQL Editor may be suitable for you. It really depends if you prefer also to be lightweight: Squirrel SQL - small footprint, universal (both source and os), ...
Kube Kubow's user avatar
2 votes
Accepted

Tool to get the most proper SQL for a predefined result

Seems to me that you are asking for a software that helps you find a "cover", a smallest set of the "Functional Dependencies" which can generate all the given rules that are ...
knb's user avatar
  • 2,864
2 votes

Command line SQL formatter or beautifier

Try out sqlformat, shipped with sqlparse Python library. The easiest way to install it is using pipx: pipx install sqlparse Here is an example of running it: $ echo "sElECt address,country,fName ...
Flimm's user avatar
  • 147

Only top scored, non community-wiki answers of a minimum length are eligible