Questions tagged [sql]
Structured Query Language - a language designed for interacting with databases.
171
questions
0
votes
0
answers
13
views
What is a good database tool for offline access?
I'm trying to find the right database service to use. I need multiple computers (1-5) to be able to access/write/read to the database simultaneously, locally (without internet access, via connecting ...
0
votes
0
answers
10
views
generating excel/text file with all table names, their columns and the corresponding Java entities and fields
Based on photo_1 with java code I would like to generate excel file as in the phote_2. Because I have lots of entities and writing it by hand would take an awfully long time. Is there a good way that ...
0
votes
1
answer
17
views
Linux CLI tool for auto-formatting (pretty printing) large SQL files
I've got a large (3 GB) SQL file that came from a SQL dump. Reading it is impossible because it's formatted poorly. For example each table has a giant INSERT statement that is indecipherable.
Is ...
0
votes
1
answer
18
views
Is there an online SQL compiler with a multi-table database for practice?
I want to practice my SQL.
My first instinct was to install a database management system (such as PostgreSQL), download a well-known database and practice on my local computer.
However, I was ...
0
votes
0
answers
12
views
Is there a T-SQL refactoring tool out there that can remove subquery statements into temporary tables?
I have recently been given a lot of T-SQL scripts that are alien to me in terms of what they do and tasked with reworking them to remove all subqueries and write them to temporary tables instead.
I ...
0
votes
1
answer
18
views
All in one solution for Oracle PL/SQL student
I am looking for something where I can develop oracle pl/sql with the following characteristics.
-That can raise a DB (DDL) in a simple way.
That supports PL/SQL, especially anonymous functions (I ...
1
vote
1
answer
34
views
Any piece of advice for audio streaming (on demand) stack, commercial, free and open source?
I could not see (m)any of free, open source, available for commercial projects, stack, from back end to front end, for flac audio streaming (not radio, but audio on demand).
To start with, is SQL ...
0
votes
0
answers
18
views
Are there tools for automated re-arrangement of SQL queries targeting readability or terseness?
When writing SQL (mostly for BigQuery, currently), I often feel my queries could be simpler/shorter, but it takes time and effort to find the simplification and I don't always succeed.
I wonder if ...
0
votes
0
answers
11
views
What is the ideal database to use for an application that will hold unique user data of an expandable list of dictionaries?
I created a fitness tracker web app, currently I am using mongodb as the database. In my app each day will be a new dictionary of various keys that I will then push to a list in the User Schema. I ...
0
votes
0
answers
44
views
First Responder Kit Power BI Dashboard alternative
I noticed that the First Responder Kit Power BI Dashboard is Discontinued.
Is there any FREE alternative for SQL Server monitoring.
For now I'm working with:
IDERA SQL Check
Database Health Monitor
...
0
votes
0
answers
18
views
SQL Server Profiler for DB2
We are working on a DB2 database and we would like to run a trace while queries are executed.
Usually in SQL Server we use SQL Server Profiler.
What is the same tool but for DB2?
(Propose more than ...
0
votes
0
answers
15
views
Ms Access encrypted .accdb convert so SQL Dump or Sqlite
Hi I have an Ms Access File .accdb encrypted and I need to convert it into a sql dump or a sqlite database on linux or mac.
I have the password.
I managed to convert in on windows with a utility and I ...
1
vote
1
answer
17
views
What software can be used to view JSON data from an API in tabular view like SSMS?
I've used SSMS (SQL Server Management Studio) to query data in tabular view from MS SQL Server. In thinking about a SaaS product that does not have direct SQL access, what is an equivalent tool that ...
0
votes
0
answers
10
views
Looking for software to import a paginated report into Excel or SQL
We have transitioned several of our DBMS functions to SSAS companies. Now, the only way to get the info back out is thru highly formatted paginated reports. I'm looking for an application to "...
1
vote
1
answer
23
views
Tool to get the most proper SQL for a predefined result
unlike to normal situation, which I write SQL Statement for pre-assumed result, I am in a situation that I need the SQL for predefined result. for example, suppose that you have the following table ...
1
vote
0
answers
85
views
Visualizing SQL query from .sql file
I have a folder of independent .sql-files that are used by a FastAPI application to request data from the Oracle Database.
Each file includes a variable (e.g. :plot_fsk) that is later on modified ...
1
vote
1
answer
77
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
0
answers
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 ...
1
vote
1
answer
20
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
1
answer
71
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 ...
-1
votes
2
answers
27
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.
2
votes
1
answer
53
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 ...
0
votes
1
answer
61
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 ...
2
votes
0
answers
24
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
3
answers
66
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
1
answer
31
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 ...
1
vote
0
answers
100
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 ...
1
vote
1
answer
26
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 ...
2
votes
1
answer
55
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 ...
2
votes
2
answers
27
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
1
answer
55
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 ...
2
votes
1
answer
256
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 ...
1
vote
0
answers
20
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
1
answer
49
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
0
answers
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 ...
1
vote
0
answers
17
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 ...
0
votes
0
answers
20
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
0
answers
16
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
0
answers
36
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
2
answers
62
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.
...
1
vote
0
answers
7
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 ...
1
vote
0
answers
50
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
2
answers
40
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 ...
1
vote
0
answers
32
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
1
answer
986
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 ...
1
vote
0
answers
121
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
0
answers
14
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
0
answers
28
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 ...
2
votes
1
answer
133
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
0
answers
14
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 ...