Questions tagged [sql]
Structured Query Language - a language designed for interacting with databases.
174
questions
0
votes
0
answers
17
views
Integrating PostgreSQL with git/Gitlab
I wonder if there is a tool that will help my team to keep a git repository (that we host on Gitlab) to synchronize with our PostgreSQL database.
The idea is that the code used to create tables and ...
0
votes
0
answers
10
views
How to shrink a huge database on a webserver, so it can be developed on and run locally
The size of the database on the webserver is on the order of 100s of GB, I can't run that locally on my PC. How do I shrink the database so I can test new features for the website?
1
vote
0
answers
10
views
Recommendations for tooling to extract scripts using table hierarchy
I am looking for a tool or open-source library which can use table dependencies to create insert scripts for PostgreSQL database.
I am working on specific requirements to clone data related to a ...
0
votes
0
answers
323
views
Need documentation for MSSQL catalog views (sys.object etc)
The catalog views are horrible to work with, probably in part from lack of documentation. Is there any good quality comnprehensive docs/books for all or some of these https://learn.microsoft.com/en-us/...
0
votes
0
answers
19
views
Any good APIs or software recommendations for scraping PC Information?
I am planning on making a web application that compares PCs together and I plan to do this by utilising APIs so I can gather data. It will comapare many factors of these PCs such as performance, price ...
4
votes
2
answers
2k
views
Command line SQL formatter or beautifier
I am looking for a command line SQL formatter = SQL prettifier = SQL beautifier (offline, not an online formatter) for Mac. The goal is to run it on the command line and also inside the editor (Emacs) ...
0
votes
1
answer
26
views
SQL Query Visualisation Tool suggestion
I am looking for a tool that gets my SQL query as input and creates a flow diagram.
I need this tool to be database agnostic, meaning, it should be able to create the flow for any query.
Any help is ...
0
votes
1
answer
23
views
Is there a low-code tool for an SQL analyst to share interactive views and graphical CRUD interfaces?
I'm looking for a graphical interface around which to have live conversations about live data; something I can leave with a client for them to browse and perhaps update as they need, in their own time,...
0
votes
0
answers
9
views
SQL Merge Statement to Mapping Diagram
The SQL Merge Statement is in our case used extensively to sync data from system A to system B and system B to system A.
This is often complexer. I'm looking for software that can turn those merge ...
1
vote
0
answers
18
views
Ways to improve my program that dumps data into excel? [closed]
So for work I have a project where I collect data from multiple databases and then dump it into excel. In my undergrad studying computer engineering I rarely did any excel automation nor do I know ...
2
votes
0
answers
29
views
FOSS data stack to perform complex custom logic on billions of ordered rows
Is there a purely analytics-focused (i.e. a handful of technial users, no business users or clients) FOSS data stack that would enable me to
ingest several hundred million up to a billion of rows per ...
0
votes
0
answers
46
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 ...
1
vote
1
answer
281
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
60
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
1
answer
25
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
0
answers
49
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
12
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 ...
1
vote
1
answer
18
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 ...
1
vote
1
answer
26
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
260
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
85
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 ...
1
vote
1
answer
46
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
2
answers
118
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
29
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.
3
votes
1
answer
78
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
64
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
25
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
70
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
42
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
142
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
40
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
140
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 ...
3
votes
2
answers
33
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 ...
1
vote
1
answer
70
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
491
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
21
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
64
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"...
2
votes
1
answer
25
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
20
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
48
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
9
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
55
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
49
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
2k
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
126
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
18
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 ...