Questions tagged [sql]

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

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

Adapting to Python/R as a SAS expert

I'm learning Python and R, because so many companies demand those skill sets now. This is me shamelessly looking for training wheels because my older habits are taking time to unlearn. I am an ...
0
votes
1answer
28 views

Ticketing System

I am thinking to create a simple desktop application. Only two computers will be used, client side and admin side. (Both connected on the same network). Purpose of the app Data to be used from ...
1
vote
0answers
10 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 ...
0
votes
1answer
26 views

How to import table data from excel into Azure FROM LINUX

I'm in a database management class and the professor strictly teaches toward windows machines, so she uses Microsoft SQL Management Studio to interface with our databases. I have a linux machine, so I ...
0
votes
1answer
16 views

Looking for a SQL Client which will allow me to query data from two different database

I am currently using a SQL Client called Dbeaver to query data from Postgresql and MySQL database individually. But recently there is a use case, where there is a need to combine data from this two ...
1
vote
0answers
27 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
1answer
47 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
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
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
27 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 ...
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 ...
0
votes
1answer
15 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 ...
1
vote
0answers
9 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
25 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
votes
1answer
24 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
26 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
8 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 ...
3
votes
3answers
117 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 ...
0
votes
2answers
20 views

I need some free softwares to make c# application setup with database

I have created a c# windows application which is simple and has simple sql database, I use SSMS to manage my database, but now is time to create a setup because I want my app to be ready to use for my ...
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 ...
0
votes
1answer
33 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
147 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.
2
votes
1answer
113 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 ...
14
votes
11answers
8k 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
15 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
20 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 ...
0
votes
1answer
20 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
1answer
23 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
11 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
9 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
190 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
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 ...
0
votes
1answer
27 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
1answer
32 views

How do I store/share data between different 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 ...
1
vote
2answers
39 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
52 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
0answers
103 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....
2
votes
1answer
31 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
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
19 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
23 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
38 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 ...
5
votes
2answers
1k 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 ...