We’re rewarding the question askers & reputations are being recalculated! Read more.

Questions tagged [sql]

Structured Query Language - a language designed for interacting with databases.

Filter by
Sorted by
Tagged with
7
votes
2answers
119 views

Software reformating SQL statements

I'm looking for an easy tool which is helping to reformat SQL statements. So e.g. SELECT foo, baa from baafoo where id > 10 and comment = 'John was it'; will become to something like SELECT ...
6
votes
2answers
171 views

Graphical SQL client

I have always used MySQL (or MariaDB, which is essentially the same thing) from the native command-line interface, which works fine. But I've recently started needing simultaneous access to both MySQL ...
5
votes
1answer
1k views

SQL server and client for Ubuntu (Debian) [closed]

I have been using MS IIS server and MS Sql client Management Studio at workplace on Windows system. My home system is a Ubuntu system and I like setup a database server and a client to interact with ...
5
votes
2answers
4k views

Web-Based Report Builder for SQL Server

I have an online tool that stores activity data in SQL Server on the backend. I want to give my users access to that data in a controlled way, so that they can mine the data and build any type of ...
4
votes
4answers
111 views

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

I have been trying to find tools which allows me to import a CSV file and perform SQL operations on it. I tried to import on SQL Dev 4 but it does not work without a local connection. The data is ...
4
votes
1answer
56 views

Object-Oriented SQL Representation

I am looking for a library that offers an object-oriented representation of raw SQL queries. With the example of SELECT statements, I imagine something like having an object that represents the ...
4
votes
1answer
121 views

Free SQL test data generator

I'm searching for a tool to generate SQL test data. What I'm looking for exactly should Be gratis Generate test data from Regex Be compatible with Microsoft SQL Server (compatibility with MySQL and ...
4
votes
4answers
3k views

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

I am looking for a tool that allows me to compare data from two SQL queries on different databases and see the rows that are different. Both databases are on MS SQL server. I have looked at following ...
4
votes
0answers
265 views

Which SQL engine atop Hadoop?

Since Hadoop came out, there have been various commercial and/or open-source attempts to expose some compatibility with SQL. I am seeking one which is good for low-latency querying, and supports the ...
3
votes
2answers
454 views

What DB engine should be used for a petabyte database?

Given: The volume of data is expected to run into petabytes over a couple of years. The full set of record types, applications and queries is not known in advance. It is expected that stakeholders ...
3
votes
2answers
166 views

Tool to generate SQL database update scripts

I'm looking for a tool or an open-source project that can generate database update scripts in the following way: Accept a database connection string as a config parameter Connect to the specified DB ...
3
votes
3answers
18k views

What is the best frontend program for my database needs?

I am currently an Electrical engineer and I have been tasked to set up a database(outside my realm of expertise) that will be used by multiple users over a networked drive. There will only be a couple ...
3
votes
1answer
54 views

I need a GUI that will edit a TEXT column in MySQL

I normally use MySql Workbench. But I now have a table that has a column of type TEXT. It is used to store Python script for use in Jython. Some of these scripts can be quite large. Workbench only ...
3
votes
0answers
39 views

Excel to SQL mapping tool

I am looking for a tool/library to import data from different clients into our SQL database. Each client will have their own EXCEL file. So the number of columns, name of the columns in EXCEL would be ...
3
votes
0answers
51 views

Database schema and data management tools

I've been using Visual Paradigm on both mac and linux to simutaneously manage my database's schema and example/test data during development. I have found their interface to only get buggier over time ...
3
votes
0answers
87 views

Free tool that can execute large SQL scripts

I have a SQL script that is too large to run it in my usual DB tool (dbvisualizer). Unfortunately I don't have access to the purchase version of dbvisualizer which would allow me to run large scripts ...
2
votes
2answers
35 views

Alternate SQL language to PostgreSQL

I am going through a course in Udemy that teaches SQL using PostgreSQL. Yesterday I wanted to solve some SQL questions on Hackerrank. But it does not have the option to write in PostgreSQL. It has ...
2
votes
1answer
37 views

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

I'm trying to find a tool which can fit my needs in the management of a list a scientific papers I read during my phd thesis. For each paper I collect title, authors, write a summary, give tags... I ...
2
votes
1answer
110 views

Faster alternative to Microsoft Access for simple ad-hoc queries

Sometimes I use MS Access 2017 to perform database tasks: Union, Filter, Join ... From time to time I receive data which I need to process, these are different, short, ad-hoc tasks, I need a tool ...
2
votes
1answer
52 views

Test data generator for MySQL

I want a tool for populating a MySQL database with random data. The data generated for the primary and secondary keys should be coherent, so the data will not cause integrity errors. It should ...
2
votes
1answer
32 views

MySQL server to receive an SQL query and convert to LDAP to query LDAP backend

The requirement is to receive an SQL query(over tcp) from a client(which is using a mysql client library - libmysqlclient.so.16.0.0) and then convert it to an LDAP request and send out to an LDAP ...
2
votes
2answers
47 views

What kind of front end should I use?

I'm an intern at an electric company and I've been tasked with producing a front end web app with display and input capabilities. What they want to be able to do is put something like this into a ...
2
votes
1answer
104 views

What is a good Python module to access data in a MySQL/MariaDB database?

I need to process a bunch of rows from a MySQL database table. I will be using Python as the programming language. Requirements: Python module reading the rows of an existing database/table data is ...
2
votes
2answers
58 views

Styled Data-Driven Reports for Print

I work at a school district and am helping to put together a project that will keep kids on track for graduation. We are able to flag a certain number of kids in our database who we can see are ...
2
votes
0answers
9 views

Text to SQL query framework

I am looking for a framework to translate text/questions/sentences to SQL queries given a relational database schema. For instance, assuming to refer to the Northwind database, the system should ...
2
votes
1answer
23 views

Ingesting word documents into internal systems [closed]

Current Problem: We have a vendor that provides us with a bill of lading in the form of a word document via email, and we are looking to ingest this information into our SQL Server database. I've done ...
2
votes
0answers
6 views

NoSQL or RDBMS for user defined columns

We will soon be rewriting an application that will allow the end user to define objects and fields on those objects. I come from an MSSQL background and am familiar with options to handle this use ...
2
votes
0answers
648 views

SQL Input Sanitization Library

I'm working with a third-party API that requires me to give it complete, runnable SQL query text - I cannot use approaches such as parameterization in order to guard against input that may break a SQL ...
2
votes
0answers
31 views

Comparison/Review Website Software

I am looking for website software (preferably open source), written in either PHP or ASP.net, where users can login and review a certain place and compare it against others in the area. Does anyone ...
2
votes
0answers
107 views

Open Source SQL Static Code Analysis Tool

Is there an Open-source SQL lint/static code analysis tool available that lets me specify custom rules? I'm thinking of something akin to Food Critic https://acrmp.github.io/foodcritic/ which allows ...
2
votes
0answers
43 views

Database / SQL history tracking

We have an existing product which is moving out of beta and will start to roll out to a large audience now. They like the product, but we've received feedback that they need some history logging. ...
2
votes
0answers
49 views

Simple database management tool

I have a very simple website complemented by a database (MySQL) with a couple of tables which are used in the website to render some pages. For ease of talk, this website simply lists a set of ...
2
votes
3answers
3k views

Reporting tool/framework/library for .Net

I want to print pdf reports with lots of charts and text on demand. I have some sub reports, which can be generated stand-alone and can also be merged to generate a single master report. Right now, ...
1
vote
1answer
20 views

SQL table handler without server/client

I am looking for a CLI program for Ubuntu 14.04 that will be able to use a file as a "database". I really don't get why every piece software I found so far has a "daemon" and a "client" part, when ...
1
vote
2answers
34 views

What database can be periodically exported to a sheet of an Excel file? [closed]

I'm developing a web-scraping tool by Python for my own use. I will run regularly the Python program to write data to a database. I hope with not too much manipulation/script we can export data from ...
1
vote
2answers
43 views

Where to create SQL databases online?

I am wanting to create my own online SQL database for a website that is going to feature some interactive r shiny/plotly apps. I see that there a appear to be a few options through things like amazon ...
1
vote
1answer
305 views

Check for duplicate column names in an SQL query

I have a rather long SQL (MySQL flavor) query and want to check if different fields queries have the same name (or alias) like SELECT a, a .... Any software for this? I use Linux.
1
vote
1answer
35 views

Is there a SQL system or wrapper that supports the actual standard as an abstraction?

I am pretty new to databases; I am currently taking an online course from Stanford about relational algebra, database design, and fundamental and advanced features of the SQL language. I am going to ...
1
vote
1answer
13 views

make-like automated build tool for relational databases

Short Version Like the question title says, I want a tool like make which will take a recipe file and use it to automatically rebuild a collection of interdependent tables in a relational database. ...
1
vote
1answer
18 views

Tool to execute commands on two SQL servers

I am learning about database transactions and isolation levels. When I want to do some experiments on what I've read in the book, there are some difficulties. First of all, I can't simply execute a ...
1
vote
3answers
95 views

Software to produce graph, chart, table from an SQL query

I'm looking for a software that is capable of connecting to a MSSQL server, execute queries and produce graph, chart or table based on the result returned. I understand that Reporting Server is able ...
1
vote
1answer
343 views

PHP Business Intelligence - alternative to metabase.com

I am searching for an openSource self hosted Business Intelligence Tool. As sonamor pointed out here, The project metabase.com ist actually very good suited BUT - it is build on JAVA/clojure and I can'...
1
vote
1answer
31 views

SQL managing software to manage/edit querys

I've got a database I need to migrate to a new format. Now I have lots of data and I need some help in changing the queries to the format the new database accepts. Does someone know software to manage ...
1
vote
1answer
119 views

tools to create SQL queries through a graphical interface

I'm looking for a tool other than Access that can create SQL queries, through a graphical interface. This is what I'm trying to do Adding some details, my database is on Postgres and I'm using the ...
1
vote
2answers
68 views

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

I recently installed MariaDB on my ArchLinux and would like to have some GUI program for me to interact with the databases more easily. I tried MySQL Workbench but it doesn't seem to connect properly ...
1
vote
1answer
63 views

SQL Data verification framework?

I receive a variety of flat files that need to be transformed and aggregated in several stages of a custom ETL process before loading it into a SQL Server database. After each stage, I'd like to ...
1
vote
2answers
141 views

Software to use as front-end for a SQL database?

I am looking for an alternative to MS Access. A simple tool that you can design a front-end for the user to be able to connect to database and enter data. Background; currently I am using Access as ...
1
vote
1answer
71 views

Database query scheduling software

I have the following scenario: A large database (postgresql). Many organizations that need to extract data from this database, each one with its own schedule and data requirements. I want an ...
1
vote
0answers
6 views

Recommendation for tool to verify data integrity in DB table

We have an SQL DB consisting of 15 different tables. These tables are being populated from 7 different data sources. I have access to the all 7 data source files (in .csv format). Now, I would like to ...
1
vote
0answers
8 views

How to structure bus timetable database be used for a public transport app? And what is the recommended approach? noSQL, SQL, API?

I'm very new to cloud data management and to be honest, I don't even know where to start looking! So please be patient if I get some terminologies wrong. I am working on a flutter app that the users ...