Questions tagged [sql]

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

Filter by
Sorted by
Tagged with
2
votes
1answer
30 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 ...
4
votes
4answers
91 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 ...
-1
votes
1answer
14 views

format column values during sql select query

I have a table with name, gender and address. Gender is stored as integer, 1 for male, and 2 for female. Now when I want to show the table, in PHP, during drawing the table I check for gender with (if ...
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
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 ...
0
votes
1answer
13 views

Visual Studio 2017 Enterprise C++ Connect to to Postgressql Server

What is the best way to connect from C++ to a postgressql server? An important limitation is that there can't be any additional software installations (some .exe or .misi files that install the driver)...
0
votes
0answers
8 views

Procedural Debuggers for Postgresql

I am curious about postgresql and would like to try it out. What other procedural debugger tools are out there? Which one do you like best and why? Here is one: https://www.pgadmin.org/docs/pgadmin4/...
0
votes
0answers
2 views

What is the best stack for a gene to disease database

I am the founder of a Genomics Diagnostic company and I am interested in understanding if anybody have built databases using Grakn and what their experience is. Kind Regards Gitte Pedersen CEO and ...
0
votes
0answers
18 views

Looking SQL Query tool

I am looking for an SQL tool that I can manage preset SQL queries. I have some SQL queries but that I need to use randomly but it would help if there any tool that will have preset SQL query and I ...
0
votes
1answer
19 views

syncing code across multiple computers

I'm looking at ways to sync my code across computers, so it can be used and edited on either. I currently code in: R python sql developer What would be the best way to do this. I was looking at ...
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 ...
0
votes
2answers
34 views

Creating a Simple Database with UI on Local Machine

I am looking to create a small database (no more than 6 tables with less than 10000 records) which can be accessed from a front end GUI which will present records to the user along with forms to ...
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 ...
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 ...
0
votes
0answers
5 views

Software to export SQL database as a graph of entity

Working on Symfony with Doctrine + SQL database, I want to export all entities of the selected table in order to allow a graph visualization. My question is : is there a software/library/bundle that ...
0
votes
1answer
19 views

Best option/opinion on how to load website data - Html/PHP into a SQL Server Database?

I have been thinking and trying to expand my knowledge of different tools. One thing I have never had personal experience with is getting website data that users enter, and have that loaded into a SQL ...
0
votes
0answers
10 views

SQL “live backup”

We are trying to achieve the following but I'm unable to find any documentation: We have a database with many 150+ tables where clients input data daily, if the devs run queries on the DB, the DB ...
0
votes
1answer
16 views

How do I store/share data between diferent devices?

I am creating an IoT system of sensors etc. for my house. Each sensor is run on a Raspberry Pi Zero. I want all the data to be stored somewhere so that a separate Zero can run a web app using flask ...
0
votes
0answers
10 views

SQL/NoSQL Engine for storing scientific data (now represented as CSV files)

I have a lot of CSV files which contain up to 20 columns with float numbers. Right now I am keeping these files in a folder. Every files is related to specific user and specific date. Files usually ...
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 ...
0
votes
3answers
49 views

Software for creating Win-Applications

I have been looking for a software solution for writing Windows applications with GUI in which I can access MS-ACCESS and SQL databases. I would prefer C#. However, I'm just looking for free ...
0
votes
0answers
7 views

Sending WordPress Data (API) to SQL table

Looking for a solution that can send our WordPress checkout data to a local SQL database in certain table. We have custom form to capture data needed from user for our YII application, just no way ...
0
votes
0answers
8 views

Tool to create easy-to-launch tool that just runs SQL queries I have written

I have created an excel macro to run SQL queries whereby the user can run the query on certain criteria which is built in on one of the worksheets. The macro is running perfectly fine. However, I was ...
0
votes
0answers
12 views

Create data entry form that loads fields from s3 and enables writing/editing data as spreadsheet back into amazon rds

I am currently maintaining a google spreadsheet to enter/edit several thousand rows for about 100 different entities - i.e. there are 10-20 rows for each entity name key (each key has slightly ...
1
vote
0answers
52 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....
0
votes
0answers
24 views

RDBMS to efficiently store 250k 12-bit images

I generate about 250k 1360x1024 12 bit images per year. The images are really just 1360x1024x1 arrays, and each pixel is a 12 bit value. When saved as a csv, the images are 4.6MB. Our default ...
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 ...
1
vote
0answers
11 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 ...
0
votes
0answers
10 views

Software for creating an app around a HeidiSQL database

I started working on a project where I created a database on HeidiSQL with a series of procedures, functions and triggers. For the next step, I need to create an app (windows or linux) that will ...
0
votes
0answers
12 views

Best tools to check SQL code

I am searching for best tools that are available in market to find anomalies in SQL code. SQL Code includes Queries, Stored procedures, Functions, etc. Expectation is to have a tool which checks the ...
1
vote
0answers
14 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
2answers
21 views

query the web by response headers and url

Do you know any service that allow you to use sql like query to find stuff on the web? I read about something like it about 2-4 months before that gather information from the world wild web but I ...
0
votes
0answers
22 views

Php free and web based reporting tool

Need help to find free and web based reporting tool for my php project. Need run it on server and create pdf/exel report based on sql/visual queries. I tried different tools but they are not good (...
0
votes
0answers
16 views

PostgreSQL query formatter which removes unnecessary parenthesis

When I ask postgres/navicat to give me the definition (DDL) of an existing view it gives a version which has way too many bells and whistles compared to what was used to create the view in the first ...
0
votes
0answers
19 views

Tool that guides converting / mapping JSON, XML, Excel based data to various SQL Table Formats

I would hope this tool would let me select columns for import from excel and then rigidly apply data type rules, allow custom conversion functions, and provide some sort of "workflow" that retains the ...
0
votes
0answers
37 views

Looking for a database server on an embedded system

So I'm looking for a database server which needs to run with the following requirements: Run on Windows XP. Log in via TCP/IP. Authentication. Expose custom stored procedures. It will be running on ...
3
votes
2answers
384 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 ...
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 ...
3
votes
0answers
38 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 ...
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 ...
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 ...
4
votes
1answer
54 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 ...
2
votes
1answer
106 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 ...
1
vote
2answers
42 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 ...
2
votes
0answers
641 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 ...