Questions tagged [sql]

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

96 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
4
votes
0answers
61 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 ...
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
52 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
90 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
18 views

Oracle SQL query optimizer (for speed/efficiency)

I'm a data analyst (novice) who writes Oracle 18c SQL queries on a regular basis. I'm aware that my SQL queries are sometimes not structured in the most efficient way possible. I have a variety of ...
2
votes
1answer
20 views

Remote Database and Table creation using MySQL and accessing information using the JAVA

I don't know if this question has been answered before but I could not find any answer so I am posting. If found duplicate I am really sorry and guide me to the original post. I am trying to learn how ...
2
votes
0answers
12 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
675 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
110 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
51 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
24 views

Choose database for multiple user desktop application

I am developing a Windows desktop application (.exe) for billing and inventory management using NetBeans. The application will run on multiple systems (10 - 12 on average), all connected in a wired or ...
1
vote
0answers
26 views

Tool for rapidly creating Web GUI for searching database on Intranet

I've a database with 20 million records in 5 tables and 150 fields. It grows by about 1%/day. We want to rapidly create an Intranet website where authenticated users can browse, filter, search and ...
1
vote
0answers
11 views

How to visualize / debug SQLite database? (python application)

What would be the best tool to debug / visualize & dig in to the a SQLite database in application development phase. The tool should be free or cheap (max. 50 USD). What kind of development ...
1
vote
0answers
10 views

Does any SQL database / CMS let you edit the data in spreadsheet / worksheet mode? (Lotus Approach did, but it's long dead.)

Can you fall in love with a database? I did: Lotus Approach. Alas, it no longer exists. PhpMyAdmin is not the same. Can any SQL database / CMS let us: work the backend data (the "worksheet"...
1
vote
0answers
8 views

Tool to save collection of pages in SSMS

I do a lot of work for various clients using SQL Server Management Studio (currently using version 18.5.1). Often, when working on a particular task, I'll have a bunch of pages open, with various ...
1
vote
0answers
11 views

Firebird or PostgreSQL for POS application - What do you recommend (any advice, experience)?

I am about to start POS application development and I can not decide between Firebird and PostgreSQL. (Firebird 3 or PostgreSQL 12) As for functionality both DBMS have everything I need. When it ...
1
vote
0answers
12 views

Is there such a thing as a “PostgreSQL-SQL-to-OtherDB-SQL” converter in PHP or at all?

I use PostgreSQL exclusively. I have no plans to ever change this. However, I recognize that other people are not me, and they instead use MySQL, MS SQL, IBM SQL, SQLite SQL, Oracle SQL and ManyOthers ...
1
vote
0answers
7 views

Library for creating MySQL queries from Java Script (other than Sequelize)?

Is there any good tool (library) to create MySQL queries from JS objects? I'm mainly interested in a low level tool, without instantialization and instance methods. Pure SQL output, but built ...
1
vote
0answers
41 views

Recommendations For examining XML

Are there any tools out there that are used to view and examine through large XML files? I work for a small company as a Data Quality Analyst and a lot of my job is looking through large XML files ...
1
vote
0answers
25 views

Editing text documents before feeding database

I hope this is the correct section for my question. I need to paste 30 text files (they all have the same format, like 30 characters for the first column, 15 for the second one, and so on) one under ...
1
vote
0answers
119 views

Tool for modifying large SQL insert statements

I am a software developer and I am working on a large project. For our unit tests we have an SQL-file with lots of insert statements for our test database (In-Memory HSQL Database). Often I am facing ...
1
vote
0answers
10 views

Query plugin for Google Sheets?

I have several related spreadsheets in Google Drive. They include what would be foreign and primary keys in a database, so I can relate records across spreadsheets. Users need to create reports (new ...
1
vote
0answers
25 views

Administrator sql queries tool

I've been asked to find a reporting solution where a non technical user administrator can search our database for mostly simple information. Such as how many users are in a specific status (and ...
1
vote
0answers
8 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

Interesting SQL queries for business intelligence and analytics

I'm looking for recommendations for either software (or a book) with lot's of cool SQL queries. The one's you use to view data in way's you'd see in a management board meeting. The software should be ...
1
vote
0answers
13 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
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
8 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
8 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
20 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
14 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
7 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
16 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
16 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
11 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
89 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
14 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
28 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
17 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
26 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
33 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 ...