Podcast #128: We chat with Kent C Dodds about why he loves React and discuss what life was like in the dark days before Git. Listen now.

Questions tagged [sql]

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

110 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
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
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
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
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
649 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 ...
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 ...
1
vote
0answers
22 views

Best Tool for Analyzing Multi-Tab Excel Files with 100-500k Records

I have started a new job and I need to analyze client's databases. Many times when we first meet with them we just get a huge Excel file with a dozen or so tabs and a partial to full dump of various ...
1
vote
0answers
13 views

Comparison tool for SQLLite that generates scripts

Can anyone suggest me software that compares SQLite tables/databases, and creates a script to update one to the other - like SQL Delta does for other database types?
1
vote
0answers
15 views

Python library like -Django- to easily create tables with a model class and access it

I was wondering if anyone knows of a library that resembles the Django DB functionality to replace the standard mysql library? So; create tables with a model class and access it like you would in a ...
1
vote
0answers
7 views

Database reccomendation for retrival of data (strings, int and float) with python

I'm looking for recommendation for the following: I currently have approximately 10 Million csv file each with the following identical data structure as file attached: I want to transfer all this ...
1
vote
0answers
7 views

What program would you use to do simple querying on tabular data?

I often receive data in Excel files and want to some simple lookups the way I would with SQL. In Excel, doing something like select b.field from a join b on a.a1 = b.a1 and a.a2 = b.a2; is doable with ...
1
vote
0answers
12 views

API Call, Copy over Cloud Database over to Local Database

Wanted to know if there is a way to copy over a cloud database through REST/SOAP Web service Calls to local db instance. For example we would recreate a database Schema in our local database. Then, ...
1
vote
0answers
7 views

Looking for a syntax evaluater for expressions constructed for use in SSRS reporting

My company currently uses the report-building suite in Microsoft's Visual Studio 2010 to construct report templates in .rdlc format based on data drawn from an SQL server. This has been working OK for ...
1
vote
0answers
5 views

Advice on which database to use for an image recognition iOS app

I am looking for recommendations and advice on which database to use for an app I am developing. I have the image recognition part of the app completed, however what I want to do now is query a ...
1
vote
0answers
12 views

WKT desktop viewer and SQL query on ODBC database

I have a proprietary database that supports SQL and has ODBC driver to connect to. it has geography columns stored in WKT format. Is there a free desktop application that I can use to connect and ...
1
vote
0answers
11 views

Tool for validating SQL Queries against different standards and Databases

I am looking for a tool (offline tool, java library, binary or such) (no online tools) which is able to validate SQL Queries against the different SQL Standard Versions or against the features of ...
1
vote
0answers
9 views

Library to retrieve tables and columns from an SQL statement

My application has an interface where the user can write various SQL statements to perform certain tests on their database tables (MSSQL, DB2, Hive, and many others). I would like to know the tables ...
1
vote
0answers
10 views

Is there a tool to modeling a db?

I'm looking for a tool that will generate a logical model of permissions for each user in my db. I've been using PgModeler, but i'm looking for alternatives that allows modeling role's permisions.
1
vote
0answers
8 views

How can I measure the performance of my SQL queries?

I am working on a data visualization software. The software generates queries based on the requested visualizations. I want to optimize the queries generated, which means that for a given ...
1
vote
0answers
59 views

Open Source ETL tool with JSON support under windows

For a old friend i "manage" his api connections and the necessary json transformations for repeating database imports. I played a lot with different tools and solutions (SSIS, Powershell, ETL Talend....
1
vote
0answers
12 views

Is there an practical SQL interface that feels like excel?

I have used SQL Server Managment Studio, and Azure Data Studio, and MySql Workbench. I wouldn't consider myself an expert on using any of those programs. However, it seems like I still do a large ...
1
vote
0answers
27 views

Need entirely free SQL database for Mobile Application

I'm in the early stages of building a mobile app (starting with Android and then IOS). Upon opening the app I want user filters to be able to query real time into the remote database and load current ...
1
vote
0answers
15 views

Software for visualizing database schema from existing SQLite database

Dear Stackexchange Community, my little problem looks like followed: I have an existing SQLite3 Database with 15 Tables and I am looking for a tool that automatically creates me a Visualisation of ...
1
vote
0answers
23 views

Free Database ERD Creator

I am looking for a free option that I can use to design my databases. The following features are a must: Needs to be free or under $100 Able to generate SQL statements to generate the completed ...
1
vote
0answers
32 views

Very fast in-memory SQL server

I have an ETL problem that's small enough to live in memory but complex enough to be managed by a team of SQL devs. What's the best way to get very fast standard-compliant SQL where concurrency isn't ...
1
vote
0answers
39 views

SQL-like graphical software for entering, creating and displaying many to many tables

I am looking for something like a GUI on top of SQL. My use case is trying to record and manage a list of servers, workflows that run on those servers, software licenses that are associated to those ...
1
vote
0answers
17 views

Middleware / interserver communication tool

I'm looking for an engine to store key / value pairs to transfer data between servers. The goal is to have a server write these values to the database and then not be able to retrieve them. Another ...
1
vote
0answers
30 views

How to execute type save sql queries with C#? or Looking for SQL wrapping API for C#

Instead of executing sql queries with plain query Strings I would like to use some kind of builder pattern to be able to execute type save sql queries in C#. In other words I am looking for an SQL ...
1
vote
0answers
63 views

Is there a terminal-only version of a SQL query editor like Sequel Pro?

I'd like to be able to do everything I can do in Sequel Pro but via a terminal interface. It should be more powerful than the MySQL cli that is just a REPL. I'd like to be able to stage queries and ...
1
vote
0answers
49 views

Type of Database for Live Streaming

I begin with a project about videostreaming with Android, specifically Live Streaming (not video on demand) The device Android will transmit video and audio, too I will have other software in desktop ...
1
vote
0answers
393 views

SQL query simplifier tool

I need a tool to simplify queries like: select usertourna0_.id as id64_0_, usertourna0_.timestamp as timestamp64_0_ from some_table_name usertourna0_ where usertourna0_.id=:p0 and not (1=0) order by ...
1
vote
0answers
47 views

No Coding Required Database Management Tool (CRM?) Equivalent to Microsoft Access

I'm looking for software where I can manage a database created from excel/Google sheets. Ideally, I'd like to import the documents into the SQL database. I have experience in SQL so set it up, however,...
1
vote
0answers
519 views

Programmatically build SQL queries in Java

We have a query that needs to be built dynamically when the user chooses search params in our GUI. I understand how to do this by hand in SQL by appending strings. While this does work there are a ...
1
vote
1answer
141 views

Light-weight SQL ETL tool compatible with Redshift

I'm looking for a light-weight SQL ETL tool compatible with Amazon Redshift. The primary (currently the only) use case would be to schedule queries that perform aggregations on Redshift tables, and ...
1
vote
0answers
16 views

Open source SQL database with BASE semantics?

Basically I'm looking for an Open-Source (or free) RDBMS with a SQL-like interface that is highly concurrent. Some features I'm looking for: A rigid schema defined at "compile-time" A production-...
1
vote
0answers
52 views

Java command line SQL interface

I want a good console SQL Client written in Java that I can use third party jdbc drivers, specifically jt400.jar with. I'd like autocompletion, history. and the ability to edit the current query with $...
1
vote
0answers
302 views

Tool that can create c++ structures from the tables of an SQLite database?

Given an SQLite .sql database file. Is there a tool that can automatically create C++ structures from its tables? For example, an sqlite schema in this form: CREATE TABLE [ACCOUNT] ( [ID] ...
1
vote
0answers
30 views

Tool to trace and create a script of all DB writes

We have a complex process that creates various entries into a large database. I would like to generate a single SQL script that performs all the writes that are done by a single run of this process. ...
1
vote
0answers
32 views

SQL Server backup with API, automated deployment, S3

I am looking for a good SQL Server backup/restore solution. There seems to be a lot of options out there, but I specifically need these capabilities: Automated deployment. It should be easy to ...
1
vote
0answers
25 views

Website for comparing SQL performance

Is there a website which allows you to paste a DDL for your DB and two SQL statements, which can then recommend one (optionally including context such as; "if >10,000 rows use Query#2; else Query#1")? ...
1
vote
0answers
42 views

FLOSS Dataflow generator for SQL

I'm looking for a (FLOSS) dataflow chart generator which is capable to build up flow based on a list of SQL queries thrown against the database. So something like SELECT * INTO myTable FROM oldTable;...
1
vote
0answers
118 views

Open-Source Web application for creating forms to query a database

What I imagine is a tool on which you can select your SQL database (ideally any of the RDBMS but if it is limited preferably PostgreSQL). In said tool administrator can create query and result forms ...
1
vote
0answers
52 views

Are there software packages that help create front-ends to SQL/RDBMS databases which can be completely customized?

I have an idea for a website where I want to build a database of items that a user can view, filter, and sort through but not alter the data. On the backend, I would want to be able to add data, ...