Questions tagged [sql]

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

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

Visualizing SQL query from .sql file

I have a folder of independent .sql-files that are used by a Fast API application to request data from the Oracle Database. Each file includes a variable that is later modified using a function that ...
1
vote
1answer
157 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
61 views

Best free database engine with built-in security for embedding in standalone Windows application

What is currently the best free SQL database engine (with built-in data security/encryption) that can be used to develop standalone Windows desktop applications? I want to create a simple Windows ...
0
votes
1answer
20 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
12 views

What DataBase is a better match?

I want to learn a Database and I'm looking for a database that has the best match with the programming languages that I use , That are C/C++ and Python . Personally I stuck between mySQL and ...
14
votes
11answers
8k 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 ...
2
votes
1answer
45 views

Any software recommendations for getting the metadata of a PDF?

I have 10,000 PDF files in my drive and I need to capture the following metadata. I tried using wordstat but I'm unable to capture the following: File Name File Type Asset Type Asset Title Product ...
1
vote
1answer
11 views

Web based tool to upload csvs -> sql table, query, and invite/ share tables with others?

I'm looking for a website that can take multiple csvs/tsvs/jsons, generate SQL tables that I can run queries against, and that's shareable with others (invite people and have them run queries against ...
0
votes
1answer
26 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
33 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
1answer
119 views

Datebase-comparing tool that supports schema and data

I'm looking for a tool which is able to compare schema as well as data of a database. Ideally for some Sybase SQLAnywhere. All what I've found was only for schema.
1
vote
1answer
28 views

Choose database for multiple user desktop application

I am developing a Windows desktop application (.exe) for billing and inventory management using NetBeans. The application will run on multiple systems (10 - 12 on average), all connected in a wired or ...
2
votes
1answer
22 views

Remote Database and Table creation using MySQL and accessing information using the JAVA

I don't know if this question has been answered before but I could not find any answer so I am posting. If found duplicate I am really sorry and guide me to the original post. I am trying to learn how ...
0
votes
0answers
10 views

LDAP proxy server that queries a MySQL database and return the data as LDAP result

I have an application storing its hashed and salted user data in a MySQL database. Users should get authenticated on other systems like XMPP with the same credentials. Since they're properly hashed ...
0
votes
1answer
45 views

Data Mining open source tools as of 2020. Any suggestions?

I have 80,000 PDFs (whitepaper, e-books) that will be used for Marketing. I'm in dire need to look for a tool (hopefully open source) for text mining, classification, categorization of the 80,000 PDFs ...
1
vote
1answer
27 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"...
0
votes
1answer
32 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
31 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
7 views

Free and Simple Database for IntelliJ

Im completely new to databases and im looking for one to use on a simple project however im not sure which one to use or how to set it up properly. Most of the videos ive seen online havnt been very ...
0
votes
0answers
13 views

Forward Engineer to SQL Server?

Are there any software like MySQL Workbench, that allows Forwarding Engineering to SQL Server? Alternatively, considering that MySQL Workbench Forward Engineering generates the SQL script, is there a ...
0
votes
0answers
8 views

Report building software

We have a web app that uses SQL Server on the back end. We decided to add reporting capability in our app. Currently, at my suggestion, we're using SQL Server Reporting Services. After repeated ...
0
votes
1answer
27 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 ...
2
votes
1answer
58 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
50 views

open source tool for SQL Queries

I program in SQL, however I am not someone who comes from IT. In my new job, we have to choose an open source tool for doing only queries (using SQL language), it means we are going to connect to some ...
0
votes
0answers
28 views

Offline REST DB

I am looking for an offline rest database so that I can provide server-side storage on my html pages without converting them to full stack server-side applications. It can be SQL or JSON based but ...
0
votes
0answers
12 views

Minimal and easy way to implement something like sharetxt.xyz?

I really like the service of sharetxt.xyz. I'd like to implement it, seems like the perfect "challange", but I feel I'm too noob to figure it out of my own. I hoped I could get some nice ...
0
votes
0answers
12 views

Recommendations for website backend/frontend direction for SMB

I am looking for helpful suggestions for a website direction (or all-encompassing solution) for an online business that markets high value items on behalf of vendors, with medium-high monthly website ...
2
votes
2answers
61 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. ...
3
votes
3answers
208 views

Tool to generate SQL database update scripts

I'm looking for a tool or an open-source project that can generate database update scripts in the following way: Accept a database connection string as a config parameter Connect to the specified DB ...
0
votes
0answers
8 views

Java library to generate SQL INSERTS (DML) from JDBC ResultSet

Does anyone know a basic, no-nonsense Java library that will generate plain/standard SQL INSERT statements (as plain String) from a given JDBC ResultSet? Similar to what you can achieve when exporting ...
-1
votes
2answers
25 views

Tool to validate domains

Does anyone know a tool that can validate a list of domains(100+ domains) in one run? Below are the sample list of domains.
0
votes
0answers
12 views

Database for trading data in real time

I looking for recommendations to store and process (a little bit) tick market data from MT4 using ZMQ. I'm willing to store around 28 different instruments, but I have some questions regarding the ...
0
votes
0answers
9 views

Data explorer for Elasticsearch or Mongo

I'm working with a large data set that includes demographics information about people (voluntary survey participants). I'd like to be able to search through this data easily, to find people that match ...
2
votes
0answers
19 views

Oracle SQL query optimizer (for speed/efficiency)

I'm a data analyst (novice) who writes Oracle 18c SQL queries on a regular basis. I'm aware that my SQL queries are sometimes not structured in the most efficient way possible. I have a variety of ...
2
votes
2answers
39 views

How to analyse and visualize complex data?

I have a Python dataframe with roughly 50.000 rows and 30 columns. This dataframe is the result of a computer simulation. 25 of the columns are input parameters of this computer simulation, the rest ...
1
vote
0answers
155 views

Open-Source Web application for creating forms to query a database

What I imagine is a tool on which you can select your SQL database (ideally any of the RDBMS but if it is limited preferably PostgreSQL). In said tool administrator can create query and result forms ...
3
votes
3answers
116 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
vote
1answer
24 views

NoSQL database for highly structured, many-index, mission-critical data with lots of relationships

I'm trying to find an alternative to SQL which is very horizontally scalable. However, many NoSQL databases have some features I need missing from SQL, or some other weird quirks. I am developing an ...
0
votes
0answers
69 views

static analysis to validate sql queries

In IntelliJ IDEs, it is possible to statically analyze SQL queries of multiple dialects (PostgreSQL, MSSQL, SnowSQL). While this is useful during development, having these steps in the CI/CD pipeline ...
1
vote
0answers
55 views

Tool for rapidly creating Web GUI for searching database on Intranet

I've a database with 20 million records in 5 tables and 150 fields. It grows by about 1%/day. We want to rapidly create an Intranet website where authenticated users can browse, filter, search and ...
0
votes
0answers
21 views

Azure SQL Managed Instance Monitoring & Alerting

I am looking for recommendation for real time monitoring and alerting solution for Azure SQL Managed instances. As per my research we can use: 1. Azure Monitor: We can use it for basic telemetry ...
2
votes
1answer
48 views

Is there a lightweight SQL-capable database management software that doesn't try to be a server?

I'm looking for a program that's specifically not an SQL server. SQL servers seem to deal with permissions, connectivity, and all that jazz. I just want a command line program that I can give an SQL ...
0
votes
0answers
11 views

NewSQL Database with remote read functionality

I am trying to perform deep learning on very large datasets which have to be stored in a NewSQL database because it has to be distributed. However, for the training process, I currently import the ...
0
votes
0answers
6 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
47 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
16 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 ...
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
18 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
15 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
14 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 ...