Questions tagged [sql]

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

Filter by
Sorted by
Tagged with
0
votes
1answer
15 views

Looking for a solid analytics tool for my team

My team currently uses Redash to create dashboards that display information of our product. We have an ETL pipeline that loads all the relevant data from multiple DB's to a MySQL database. We then ...
0
votes
0answers
5 views

A database that is highly optimised for sequential read and writes that interfaces to Python

I'm doing a Monte Carlo study in which I am doing two things asynchronously: Generating virtual scenarios (and storing them) Running them through an algorithm (loading the virtual scenarios and then ...
1
vote
1answer
151 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 ...
1
vote
1answer
37 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
vote
0answers
6 views

How to visualize / debug SQLite database? (python application)

What would be the best tool to debug / visualize & dig in to the a SQLite database in application development phase. The tool should be free or cheap (max. 50 USD). What kind of development ...
0
votes
1answer
16 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
11 views

Framework suggestion to convert JSON to SQL

Are there any frameworks that can converts JSON to SQL. We have MDX which is for OLAP based systems. The use-case that I am working on allows users to add flat data and create a table and run SQL on ...
0
votes
1answer
22 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
28 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
7 views

Does any SQL database / CMS let you edit the data in spreadsheet / worksheet mode? (Lotus Approach did, but it's long dead.)

Can you fall in love with a database? I did: Lotus Approach. Alas, it no longer exists. PhpMyAdmin is not the same. Can any SQL database / CMS let us: work the backend data (the "worksheet"...
1
vote
0answers
8 views

Tool to save collection of pages in SSMS

I do a lot of work for various clients using SQL Server Management Studio (currently using version 18.5.1). Often, when working on a particular task, I'll have a bunch of pages open, with various ...
0
votes
0answers
15 views

Database solution to identify mechanical parts (CAD files) in an assembly

I am working with a CAD assembly (a collection of mechanical parts put together) in Solidworks, and an Excel spreadsheet, which describes its components. I want to transition the Excel spreadsheet to ...
1
vote
0answers
11 views

Firebird or PostgreSQL for POS application - What do you recommend (any advice, experience)?

I am about to start POS application development and I can not decide between Firebird and PostgreSQL. (Firebird 3 or PostgreSQL 12) As for functionality both DBMS have everything I need. When it ...
1
vote
0answers
10 views

Is there such a thing as a “PostgreSQL-SQL-to-OtherDB-SQL” converter in PHP or at all?

I use PostgreSQL exclusively. I have no plans to ever change this. However, I recognize that other people are not me, and they instead use MySQL, MS SQL, IBM SQL, SQLite SQL, Oracle SQL and ManyOthers ...
0
votes
0answers
19 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, ...
2
votes
2answers
53 views

Open Source Knowledge Site

Basically I'm looking for a solution that's a lot like what you'd find for 'documentation' on sites like php.net There'd be an admin backend and also a user front end that displays the information. ...
0
votes
1answer
22 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 ...
0
votes
1answer
23 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 ...
1
vote
0answers
6 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 ...
6
votes
5answers
2k 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 ...
0
votes
0answers
5 views

Is there an extension for Azure Data Studio that places a guideline at 80 characters?

Question: I use the extension Editor Guidelines in Visual Studio. Are there any similar extensions for Azure Data Studio? Workaround If not, is there any way to mimic this using an existing ...
1
vote
0answers
39 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
31 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
8 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
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
21 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
11 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
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
37 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
9 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 ...
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
8 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
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
11 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
7 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
15 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
9 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
19 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 ...
0
votes
0answers
8 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
11 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
12 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.