Questions tagged [sql]
Structured Query Language - a language designed for interacting with databases.
161
questions
0
votes
0answers
11 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
10 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 ...
0
votes
0answers
3 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
22 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
1answer
34 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
1answer
35 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 ...
0
votes
0answers
11 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
7 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
32 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 ...
0
votes
0answers
37 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
1answer
26 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
0answers
33 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
1answer
22 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
20 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
46 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
1answer
21 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
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
1answer
27 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
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
0answers
16 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
0answers
14 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
1answer
22 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
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 ...
1
vote
0answers
13 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
0answers
17 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
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 ...
0
votes
0answers
25 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
2answers
59 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
0answers
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 ...
0
votes
0answers
8 views
Is there an extension for Azure Data Studio that places a guideline at 80 characters?
Question:
I use the extension Editor Guidelines in Visual Studio.
Are there any similar extensions for Azure Data Studio?
Workaround
If not, is there any way to mimic this using an existing ...
1
vote
0answers
44 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
2answers
33 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
0answers
25 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
1answer
107 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
0answers
119 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
0answers
10 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
0answers
25 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 ...
1
vote
1answer
47 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
0answers
9 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 ...
-1
votes
1answer
30 views
Should I learn MySQL and SQL server together for learning SQL? [closed]
I am starting to learn SQL so I was wondering which RDBMS should I use, i.e. MySQL or SQL Server, so I can also mention that tool in my resume to give good impression to get a job here in India.
So ...
-1
votes
1answer
9 views
Adapting to Python/R as a SAS expert
I'm learning Python and R, because so many companies demand those skill sets now. This is me shamelessly looking for training wheels because my older habits are taking time to unlearn.
I am an ...
0
votes
1answer
28 views
Ticketing System
I am thinking to create a simple desktop application.
Only two computers will be used, client side and admin side. (Both connected on the same network).
Purpose of the app
Data to be used from ...
1
vote
0answers
9 views
Interesting SQL queries for business intelligence and analytics
I'm looking for recommendations for either software (or a book) with lot's of cool SQL queries. The one's you use to view data in way's you'd see in a management board meeting.
The software should be ...
0
votes
1answer
25 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
13 views
Looking for a SQL Client which will allow me to query data from two different database
I am currently using a SQL Client called Dbeaver to query data from Postgresql and MySQL database individually. But recently there is a use case, where there is a need to combine data from this two ...
1
vote
0answers
18 views
How to structure bus timetable database be used for a public transport app? And what is the recommended approach? noSQL, SQL, API?
I'm very new to cloud data management and to be honest, I don't even know where to start looking! So please be patient if I get some terminologies wrong.
I am working on a flutter app that the users ...
1
vote
1answer
45 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
votes
1answer
10 views
What Database type should I use for a scraped data comes from many websites?
I'm building a REST API using NodeJS storing a scraped data that comes from many websites ( the API I'm building is about selling - buying used cars )
There's a potential to scale in the future ...
1
vote
0answers
13 views
Comparison tool for SQLLite that generates scripts
Can anyone suggest me software that compares SQLite tables/databases, and creates a script to update one to the other - like SQL Delta does for other database types?
