Questions tagged [sql]

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

Filter by
Sorted by
Tagged with
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 ...
Mefitico's user avatar
  • 135
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?
thedankvank's user avatar
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 ...
prashant's user avatar
  • 111
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/...
user3779002's user avatar
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 ...
Adel's user avatar
  • 1
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) ...
Timur Shtatland's user avatar
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 ...
Mukesh K's user avatar
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,...
Travis Well's user avatar
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 ...
edelwater's user avatar
  • 236
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 ...
smichael_44's user avatar
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 ...
McPeanutbutter's user avatar
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 ...
user16369266's user avatar
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 ...
Freedom_Ben's user avatar
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 ...
Arturo Sbr's user avatar
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 ...
Illidan's user avatar
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 ...
Soleil's user avatar
  • 111
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 ...
tester0001's user avatar
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 ...
user3513237's user avatar
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 ...
DragonInCresent's user avatar
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 ...
Taras's user avatar
  • 11
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 ...
Gabriel Del Leonés's user avatar
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 ...
CorerMaximus's user avatar
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 ...
Vicky's user avatar
  • 1
-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.
Michellin Yumul's user avatar
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 ...
Bowie Maris's user avatar
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 ...
Bowie Maris's user avatar
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 ...
User1974's user avatar
  • 121
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 ...
7824238's user avatar
  • 123
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 ...
Prasanna S's user avatar
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 ...
Arthur's user avatar
  • 111
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 ...
id01's user avatar
  • 111
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 ...
schuelermine's user avatar
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 ...
BATMAN_2008's user avatar
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 ...
Yuv_c's user avatar
  • 11
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 ...
Niko Fohr's user avatar
  • 141
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 ...
unnik's user avatar
  • 111
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"...
Jonathon Neville's user avatar
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 ...
user1401286's user avatar
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 ...
EmirZ's 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 ...
Omnistic's 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 ...
Mansel Cayler's user avatar
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, ...
Kwsswart's 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. ...
Randy Brown's user avatar
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 ...
Eggon's user avatar
  • 111
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 ...
Jeremy Pixley's user avatar
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 ...
rhobro's user avatar
  • 11
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 ...
Unnamed's user avatar
  • 111
-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 ...
J Arun Mani's user avatar
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 ...
Matthias Nicklisch's user avatar
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 ...
Marion's user avatar
  • 21