Questions tagged [sql]

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

Filter by
Sorted by
Tagged with
0
votes
1answer
16 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
3 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
votes
0answers
6 views

Read mcdb database

We have a program that save data in database with extension mcdb. What program can i use to connect to this database. There is possible to connect via SSMS? Thank you
-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
17 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
0answers
5 views

CONNECTION PROBLEMS WITH THE SQL SERVER [closed]

I have tried to connect to the SQL Services Analysis from my machine to a windows server 2008 remote server, but i have the following error, someone knows that i must configure in the management to ...
-2
votes
0answers
7 views

Beginner path: ¿Mongo or SQL? [closed]

I'm a student and I want to know what db I must to learn for web development ¿MongoDB or SQL?
1
vote
0answers
8 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?
0
votes
0answers
9 views

what language+framework for db front end development? [closed]

I work for a small company as an applied scientist and as a secondary task I have created MS Access Database to track some data about our production. The Database has grown so now we migrated the ...
1
vote
0answers
14 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
9 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 ...
3
votes
3answers
17k 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 ...
1
vote
1answer
139 views

Light-weight SQL ETL tool compatible with Redshift

I'm looking for a light-weight SQL ETL tool compatible with Amazon Redshift. The primary (currently the only) use case would be to schedule queries that perform aggregations on Redshift tables, and ...
0
votes
0answers
19 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. ...
-1
votes
0answers
2 views

I need R and a database on azure

I need to built an app with large amount of data (in the cloud). I am using R (its a given) for dataprocessing, but for me its a bit unclear how to proceed. I think i will do it in AZURE, creating a ...
0
votes
0answers
4 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
3 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
1answer
13 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
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 ...
-2
votes
0answers
10 views

HOW TO GENERATE PDF TICKETS FROM A DATA SOURCE

I am developing an online event booking application where users can book for an event on the platform and the application should generate a ticket from the provided information and send it (the Ticket)...
-3
votes
0answers
14 views

SQL 2008 - SQL 2016

Can anyone recommend a software upgrade from SQL 2008 to SQL 2016? What are the benefits / disadvantages to upgrading? How did it impact you? Positives / negatives? Thanks
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
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 ...
-1
votes
0answers
8 views

ASP.Net Core 2.2 MVC Code first existing database

I have Watched tutorials using asp.net core 2.1 to achieve this. MY question is I can not follow the same procedures using ASP.Net Core 2.2. Is it a feature of EF that is no longer available or am I ...
0
votes
0answers
6 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
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
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
94 views

Recomended SQL client for AWS Athena that supports queries sharing

I'm looking for the best sql client to use with AWS Athena (with JDBC driver). One of my needs is to share the queries between users, and I would like to know how can I do it in the best way. The ...
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
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 ...
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
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
11 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, ...
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 ...
2
votes
1answer
23 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
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
5 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
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
10 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
0answers
11 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.
0
votes
1answer
13 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 ...