Questions tagged [sql]
Structured Query Language - a language designed for interacting with databases.
171
questions
1
vote
2answers
20 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 ...
0
votes
0answers
5 views
Documenting stored procedures
I'm searching for a SQL script or a freeware to document stored procedures batch, from the point of entry to tables and depending stored procedures. It should analyse all stored procedures regarding ...
1
vote
0answers
23 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
18 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 ...
0
votes
0answers
7 views
Convert SQL query to graphic model
I am looking at complex SQL statements and wondered if there's a free tool (online, python library...) which can represent the query into a graphical model.
For example:
You have a select query ...
1
vote
0answers
118 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 ...
0
votes
0answers
8 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 ...
1
vote
0answers
24 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
1answer
31 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 ...
0
votes
0answers
17 views
Whats my next database setup?
Currently I am running a windows server with sql server - and SSMS.
But I am a bit tired of windows and ms - love the sql server and ssms though.
My desktop is running linux mint, so I remote ...
1
vote
0answers
8 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 ...
0
votes
0answers
14 views
SQL SERVER performance OPEN SOURCE monitoring
I'm searching for good open-source solution to monitoring SQL SERVER performance, It will be nice if it has a web client.
I have 32 SQL SERVER instances and 11 Windows Servers, I want to collect data ...
0
votes
0answers
5 views
Creating an excel arc that communicates with SQL
I have a website that stores orders. Foreach order, there is(should be created) an excel arc, where some of the fields should be filled by me, and the rest should be filled by the customer. The ...
-1
votes
1answer
7 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
26 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
7 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
0answers
6 views
Which SQL Server Standard version will run on Windows 7 Embedded?
I want to load Microsoft SQL Server Standard on Windows 7 Embedded but don't know which versions (2012,2014, etc...) of Standard can run on Windows 7 Embedded.
I would like to use CALs instead of ...
0
votes
0answers
6 views
Is there a software (like OpsGenie) that will show whether or not stored procedures have run on Microsoft SQL Server?
I'm looking for a web app (or something similar) that is able to show super simple statuses of stored procedures (or groups of stored procedures) similar to the way OpsGenie works. All I want it to do ...
0
votes
0answers
6 views
Is there a free software that lets me send commands if there is data in a SQL view
Is there a free software (could be a service too) that detects when there is data in a certain MS SQL view, and then can trigger a custom command to a certain server on a certain port?
I am trying to ...
0
votes
0answers
12 views
Tool to create documentation from a SQL query
At my company we have a project where we write select SQL queries on different financial software databases to insert into a pre-designed database table we created.
An example query would be:
...
0
votes
1answer
17 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
7 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
0answers
6 views
Scraping Wikipedia to build a database of musicians and their hometown/origin
I have to scrape Wikipedia to create a SQL database of musicians and producers along with their hometown or origin. What are some tools/programs I can use? Thanks so much!
1
vote
0answers
8 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
0answers
10 views
OLTP or OLAP for Batched Transactions
Which database paradigm should I leverage to support a Relational Database, which is updated as a weekly batch, and which supports typical analytics query-patterns.
From the RDBMS-side I need to ...
0
votes
0answers
4 views
What's your software/framework recommendations for building a CRUD application in java in a smart way
our firm develops softwares for business which mostly has CRUD (Create, Read, Update, Delete) functions. The software is quite big and provides several features to handle their data. And the data is ...
0
votes
0answers
3 views
Do we have any package/library to read excel files in Oracle 12 and above?
I need a suggestion on how to read excel files in oracle. Is there any library/package that simplifies the work.
0
votes
0answers
4 views
( Angular 2 [V.8] + ASP NET + SQL ) Need a search engine/plugin that is going to work like Stack exchange's related questions query or elastisearch
So I'm building an application for my organization that, just like Stack Exchange when you ask a question it searches the for similar / related questions. I am using Angular 2 on the front end and ASP ...
0
votes
0answers
15 views
Help developing a golf score tracking mobile application
I, along with three other people, are assigned a project for our upper-level college course. We are responsible for creating a mobile application for our schools golf team. Here are the specifications ...
0
votes
0answers
5 views
Tool to manage (sql) queries
I'm looking for a tool that will allow us to manage (create, update, delete) queries in an online platform and that is accessible via an API.
Some context, we have lots of queries that are ...
0
votes
0answers
6 views
Simple Python Web App to Display Result Sets from Different SQL and MySQL DB w/ Multi Connections
I have system metrics stored in SQL and MySQL tables on a few different connections. I want to display these as a helpful Systems Monitor UI for those on the network that they can access through their ...
0
votes
1answer
7 views
Framework for T-SQL unit testing
I am looking for a framework to do unit testing of T-SQL stored procedures and functions.
1
vote
0answers
22 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
9 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
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
9 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 ...
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
21 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
7 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 ...
