Questions tagged [sql]

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

Filter by
Sorted by
Tagged with
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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
  • 111
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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
  • 101
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 ...
user avatar
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 "...
user avatar
  • 101
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 ...
user avatar
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 ...
user avatar
  • 11
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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
  • 1
-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.
user avatar
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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
  • 121
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 ...
user avatar
  • 123
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 ...
user avatar
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 ...
user avatar
  • 111
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 ...
user avatar
  • 111
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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
  • 1
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 ...
user avatar
  • 131
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 ...
user avatar
  • 111
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"...
user avatar
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 ...
user avatar
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 ...
user avatar
  • 111
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 ...
user avatar
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 ...
user avatar
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, ...
user avatar
  • 101
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. ...
user avatar
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 ...
user avatar
  • 111
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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
  • 111
-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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
  • 21
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 ...
user avatar
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 ...
user avatar
  • 123
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 ...
user avatar