Questions tagged [sql]
Structured Query Language - a language designed for interacting with databases.
0
votes
0answers
10 views
RStudio or SQL for data cleaning
I am wanting to detect corrupt and inaccurate records to check for data quality from large data sets that originate from Microsoft Access and Excel.
Things I would like to check for:
Validity which ...
0
votes
0answers
7 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
votes
0answers
5 views
JUnit roll back on updating test [closed]
Would you tell me how to test in JUnit.
some data are updated by methods.
After doing test, it needs to restore.
How should I code?
0
votes
0answers
7 views
Is there an equal to SQL for storing images?
I'm rather new to SQL, Python, & programming in general so please be nice. I'm wondering if there's an equal to SQL for storing images in a lightweight database, or something of the sorts. Or if ...
0
votes
0answers
2 views
Tag questions of survey in Warehouse
I have a survey with 10 questions. 50 Persons have completed the survey, so I have table with 500rows in my table XXX.
Issue: I have one column in table XXX that is the question. So 500 columns where ...
0
votes
1answer
15 views
Report distribution tool
we are looking for a SW/tool which would help us to automate the reports distribution.
We use MS SQL Server 2016 and SSRS (Sql server Reporting Services), we have a knowledge of SQL coding.
Our ...
0
votes
0answers
9 views
generate and validate an SQL query on Angular 6 UI
I have a requirement to generate and syntactically validate an SQL query on Angular 6 UI. Any recommendations for any libraries/plugins which are available and easy to use would be appreciated.
-1
votes
0answers
7 views
Mysql with asp.net and visual studio 2019
after working on a .NET apllication with Visual studio for a week finishing up some basic layouts, I wanted to move in to the back end and get a database setup to reference. So I went to the mysql ...
-1
votes
0answers
8 views
Database for Android app recording vehicle mileage driven by various drivers
I built an android application that can provide information about various vehicles (last driver, distance etc ... ). There would be really few user (<100persons, but must be hack safe)
Now I would ...
-2
votes
0answers
3 views
Migrating an Oracle database to MS SQL Server: SSMA or ESF
What are the pros and cons of using SSMA and ESF Database Migration Toolkit? Is one easier to use/more reliable than the other?
1
vote
1answer
18 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 ...
-1
votes
0answers
4 views
Need to Install MS SQL Server 2014 Standard but I can't find the Installation files in the Microsoft Website
I have a standalone application that requires MS SQL Server 2014 Standard. I went through the Microsoft Website and I only can find installation for Express edition or the Service Packs for SQL 2014.
...
-1
votes
0answers
5 views
Why can't I connect mobile app to SQL database in Azure
I have a free Microsoft Azure account and I am unable to connect my mobile app with SQL database in Azure. The Azure documentation guide is not the same information I see in my Azure portal so the ...
4
votes
4answers
79 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
11 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
6 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
7 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
0answers
7 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
14 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
10 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
9 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
27 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
8 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
17 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
9 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
13 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
8 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
33 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
6 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
9 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
6 views
Database Quality Checker [closed]
Can anyone suggest me best tool for database design creation and checking existing database along with code quality checker for procedure, function and and other SQL code.
Thanks
1
vote
0answers
31 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
23 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
21 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
10 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
26 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
12 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 (...
