Questions tagged [sql]

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

Filter by
Sorted by
Tagged with
-1
votes
1answer
10 views

What Database type should I use for a scraped data comes from many websites?

I'm building a REST API using NodeJS storing a scraped data that comes from many websites ( the API I'm building is about selling - buying used cars ) There's a potential to scale in the future ...
1
vote
0answers
27 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 ...
0
votes
0answers
10 views

Need to move 200+ tables from OData source to a SQL database

I have an OData URL with 200+ tables and I need to create all the tables in a SQL database and copy data daily to the SQL database. An additional requirement is to be able to easily change the ...
0
votes
0answers
10 views

Which environment to use for SQL

I'm not quite sure how to google this question, as I keep getting mixed results. I have a set of data I want to work with. I have a function that pulls the correct data that uses MySQL 5.7 (I ...
3
votes
3answers
21k 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 ...
0
votes
0answers
20 views

I am trying to automatically extract data from a database (MSSQL)

I am using MS SQL Server Management Studio right now, but it would be cool to use the 'Jobs' function to have some SQL run (a select statement) and create CSV file is a specific folder on the server. ...
0
votes
0answers
6 views

How can I build a dashboard with an integrated NLP search bar?

One idea was to build a dashboard in D3.js and add a search bar which with NLP to SQL functionality so that it can create visualisations based on what the user has searched for in Natural Language. ...
0
votes
0answers
4 views

Optimal DB for bulk inserts with unique constraint on binary data field

I am trying to find the optimal DB for inserting binary data many times, when theres a unique constraint on it - there is a hash identifying each record, that can't be repeated. I'm interested only in ...
0
votes
0answers
7 views

Need a Client Portal for SQL Driven Reports with Simple Client Workflows

I am looking for a database solution that is SQL based, cloud-hosted and provides a customizable reporting dashboard for our clients to log into and review reports (multiple clients, segregated). ...
0
votes
0answers
7 views

Handle Time Zones on Centralized Service

I have windows service (.net) where the service has to expire the transaction values after set time. In database server all the transaction times are saved as UTC. Expiration should be automatically ...
0
votes
0answers
23 views

Linting and Formatting for Vertica SQL

Is there a (Linux) command-line tool or a library (preferably a Python library) for formatting Vertica SQL? I'm thinking of something similar to pylint and/or black for Python. The closest thing I've ...
0
votes
0answers
8 views

Best Free SQL Program to Upload Excel CSV file

I am looking for a free program that works with Mac and is able to upload an Excel CSV file. The reason for this request is because I have an interview and the company gave me an assignment to write ...
0
votes
0answers
26 views

Looking for a SQL result exporter tool for non-tech end users

Six years ago we built a homemade tool for our internal users to download CSV files based on a SQL query. There is two kind of users : Admins who can define a SQL query with parameters Users who can ...
0
votes
0answers
8 views

Software to display hive /hadoop sql results

I am looking for a software that displays my hive query results in a tabular format.We have to convert each query into csv and then transfer the csv to local in order to get the results. Previously ...
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 ...
0
votes
1answer
14 views

Is there a tool to view entity relations from a sql script?

I have a sql file with a long list of create tables and alter tables. Is there a tool available to look at the entity relationships that result from running the sql script. It would be great to not ...
2
votes
2answers
49 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 ...
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
votes
1answer
21 views

SSRS - SQL Server Reporting Services Possibility?

Currently, we have SQL Server 2012 R2. Looking to produce some reports and have them automatically run and have converted to PDF with the possibility of automating an email to send to subscribers of ...
1
vote
0answers
19 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, ...
2
votes
1answer
53 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
vote
0answers
10 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 ...
0
votes
0answers
13 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 ...
1
vote
0answers
15 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 ...
0
votes
0answers
49 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.
5
votes
1answer
66 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 ...
-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
14 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 ...
0
votes
2answers
44 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
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 ...
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
11 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
3answers
51 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 ...
1
vote
2answers
36 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
0answers
81 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
26 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
26 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
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
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
16 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
72 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 ...
0
votes
0answers
20 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 ...