The Stack Overflow podcast is back! Listen to an interview with our new CEO.

Hot answers tagged

5

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 application to access SQLite files is provided on the project website, as well. One of its supported output modes is CSV. I cannot currently try whether it ...


5

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. Almost all database browsers offer import from CSV; if you want a lightweight one, I can recommend SQLite Browser. It's open-source, cross platform (Windows, ...


3

I like the SQLBeautifier plugin for SublimeText. SublimeText is cross-platform (Windows, Linux, and OSX) and has a free trial with unlimited functionality. The plugin itself is free and open source (MIT Licensed). Installation is quite simple - just run installer for SublimeText, open SublimeText and install Package Control, then in Sublime Text type ctrl-...


3

http://www.sql-format.com/ lets you format things with quite a lot of control if you can cope with a web interface rather than a command-line tool:


3

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 connected with OLEDB, ODBC or .NET connectors. The free edition allows to create once comparison project and unlimited number of connections. Here's a screenshot of ...


2

Check out QLR Manager Relatively inexpensive when comparing with other applications This application is completely web-based, It works with well with MS SQL


2

I recommend you use PostgreSQL. It is a very advanced relational database system. Its very close to the ANSI-SQL:2008 standard and has a lot of features that might come in handy further down the road. If you are just starting to get to know relational databases Postgres will teach you a lot of function that you will find (in one way or another) in other ...


2

There is no DBMS that implements the entire SQL standard. Depending in what programming language you are developing, there always are interfaces for communicating with a DBMS through SQL commands (e.g. OLEDB, ODBC). The most important thing to keep in mind is that the "dialects" you are referring to are almost identical. That is, the difference between ...


2

I would recommend Mockaroo.com. It does generally what you are looking for and i think it should be able to get the job done. Here is what it can do. generate test data(up to 1000 rows) it generates very realistic data you can download the data in the form of a sql file It does not make a direct connection to the database. It also cannot generate data with ...


2

I think the only safe way to do this is on the DBMS side. Like you said, some user might do something wrong by accident, or worse, could do something wrong on purpose. In SQL Server you can add the user to the db_datareader role which only allows the user to do SELECT: Members of the db_datareader fixed database role can run a SELECT statement against any ...


2

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 there are duplicate column names, this fails... and gives you one of the duplicate names. ERROR 1060 (42S21): Duplicate column name 'foo' Note also that if ...


2

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.


2

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.


2

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 Data Generator Features: List item Generate Unique Values Generate Optional Values Foreign Key support (multiple tables) Numeric values (integer numbers, float ...


2

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 software) it can deal with the data sizes you've mentioned just easily (I use it with databases several Megabytes in size – other projects use SQLite databases even ...


2

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. About your requirements: Anything that lets me add tables, restrictions, projected columns, subqueries, etc., in an arbitrary order (i.e. not necessarily ...


2

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 do most or all of these things. Consider the following. The small red arrow shows that there is more text that cannot be seen. Double-click on the line in ...


2

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 community.


2

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://pypi.org/project/querycsv/, which I wrote). If you use R, you can use read.csv to import the data to a data frame, and use the sqldf package to query it ...


2

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 dataframe. Python - pandasql library has the same functionality over pandas dataframes.


2

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 command line. If you pass standard input to csvsql, then the table is named stdin. csvsql --help Generate SQL statements for one or more CSV files, or execute ...


1

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 administrators and analysts. Supports all popular databases: MySQL, PostgreSQL, MariaDB, SQLite, Oracle, DB2, SQL Server, Sybase, MS Access, Teradata, Firebird, ...


1

For your need i think sqlyog will be the best product it is although not free but you will get 30 day trial for premium version and support for this. You can edit text type like this. Your text field will retain formatting of your code. It has community version too. Edit I am not sure about sqlyog running on linux environment so you have to use wine for ...


1

I had been myself searching for this for a long time. Although the following did not suffice my use-case, probably, they might for you. http://www.reportico.org/ https://mydbr.com/ https://www.koolreport.com/ Kool Report should be most relevant to you use-case


1

TLDR version - local mysql server, local apache server w/ php support, and phpmyadmin If you have your existing queries, and a sample dataset that hits all the combos, you could load it all up in phpMyAdmin and work with it in-browser. View or create relationships, run queries, edit/delete/insert data, etc. Save queries, export data, all sorts of good ...


1

Pandas provides a database abstraction layer over SQLAlchemy with a fallback to sqlite. Read the rows of an existing DB - Definitely but conceptually when using pandas dataframes you tend to think in columns data can be read from tables or queries. Data is not text only - Yes: Pandas dataframes contain real, typed, data objects. Support MySQL - Yes via ...


1

On PgAdmin3, there is a graphical query builder (see the right tab on the upper left side of the animated gif)


1

Syncfusion Report Platform is an option to consider. Based on SQL Server: Yes Web oriented: Yes. Quick to Build: Syncfusion Report Platform uses the same file format (RDL) as SSRS. A Desktop designer is provided for creating reports Easy to Debug: The system is simple end accurate error messages are displayed to be able to troubleshoot problems. The ...


1

SQL Power Architect stores its definition as an XML file. However, I find that format quite hard to use from e.g. XSLT. But it also supports the Liquibase XML format for "forward engineering" which is easier to process then the format Power Architect uses (at least in my opinion).


1

I'm still a little unclear. Couldn't you use Python to query the database and use that result to generate XML? Ah, " my country's open data, and the relationships between them". So, not necessarily every piece of data, but the relationships between tables, for instance? If you have access to the meta data (schema). It you do, this shouldn't be difficult. ...


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