Questions tagged [sql]

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

Filter by
Sorted by
Tagged with
0
votes
0answers
25 views

Database for student and progress attendance web application

In the project I want to do I will be requiring a database for the following: Store and access login details for Admin, Managers and Faculty. Store students and their information, i.e. Phone numbers, ...
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
45 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
2answers
35 views

Distributed Database Systems

I am looking for an open source distributed SQL database system which will distribute the data across nodes but so that there is data redundancy (if one node fails, the data is still available without ...
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
votes
1answer
372 views

How can I check if my SQL query is right without executing it?

Its similar to https://stackoverflow.com/questions/377883/how-to-check-if-mysql-query-is-valid-without-executing-it But its for Go and I want a solution in Python. It will be better if there is a ...
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
1answer
69 views

Alternative to SQL Server Management Studio for Ubuntu

I am looking for an alternative to SQL Server Management Studio for Ubuntu. I have worked with Pycharm Pro so far but I currently don't have the Pro version. I looking for a noob friendly and with a ...
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
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 ...
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

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
votes
1answer
30 views

Should I learn MySQL and SQL server together for learning SQL? [closed]

I am starting to learn SQL so I was wondering which RDBMS should I use, i.e. MySQL or SQL Server, so I can also mention that tool in my resume to give good impression to get a job here in India. So ...
-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 ...
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
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 ...
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
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 ...
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
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 ...
3
votes
3answers
24k 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
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
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
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, ...
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 ...
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 ...
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
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.
5
votes
1answer
70 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
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 ...
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
187 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
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
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
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 ...
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 ...