Questions tagged [sql]
Structured Query Language - a language designed for interacting with databases.
138
questions
0
votes
0answers
10 views
+50
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
6 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
0answers
5 views
Raw SQL queries or an ORM like Sequelize [closed]
I am creating a node js application for my college project. I want to know which is faster and efficient? An ORM like Sequelize or writing raw SQL queries?
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 ...
-1
votes
0answers
8 views
why and when use Function in sql server, what is difference between stored procedure and function [closed]
Please provide answer with example, what is need of sql Function, when shoud go for function and when go for procedure
0
votes
0answers
4 views
Software for plotting data live from Big Query
Is there any software which can plot data into a live graph. The SQL table is in Google's platform (Big Query) and the graph should be updated in real time.
If not, is it achievable in Python? And ...
1
vote
0answers
7 views
I am trying to get a list of zipcodes which are duplicates in more than two states and the query below is throwing a syntax error [closed]
select ZIP, count(distinct STATE) COUNT , STATE from DATA_TBL
group by ZIP, STATE having count > 1;
1
vote
0answers
7 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
5 views
SQL question queuing [closed]
Hello so I need to create an app where user will answer to questions. And what is the best optimal way to save queue of question so the same don't repeat. I thought about create in table user like ...
1
vote
0answers
10 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
20 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 ...
0
votes
0answers
3 views
SQL 2017 clr strict security feature enabled prevent creating assemblies that we have varbinary only
I have many assemblies on SQL server 2008, that i don't have their dll, so when i'm trying to create those assemblies on SQL 2017 an error occors, "Msg 10343, Level 14, State 1, Line 106
...
1
vote
0answers
7 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
4 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 ...
2
votes
2answers
33 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
votes
0answers
7 views
Migration from SQL to NoSQL
My application is already running using Oracle DB and have lots of transaction process.
I am considering to replace oracle with Mongo or other NoSQL DB.
Now can anyone help me to take the right ...
0
votes
1answer
12 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 ...
0
votes
0answers
11 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
9 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
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
17 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
10 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
20 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 ...
4
votes
4answers
81 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
12 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
1answer
11 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
15 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
12 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
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
30 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
9 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
7 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
11 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 ...
