Questions tagged [sql]
Structured Query Language - a language designed for interacting with databases.
169
questions
0
votes
0answers
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
0answers
11 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
0answers
6 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
0answers
11 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
1answer
14 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
0answers
8 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
1answer
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
0answers
53 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
1answer
73 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
0answers
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
1answer
15 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
0answers
51 views
LDAP proxy server that queries a MySQL database and return the data as LDAP result
I have an application storing its hashed and salted user data in a MySQL database. Users should get authenticated on other systems like XMPP with the same credentials. Since they're properly hashed ...
0
votes
0answers
7 views
Free and Simple Database for IntelliJ
Im completely new to databases and im looking for one to use on a simple project however im not sure which one to use or how to set it up properly. Most of the videos ive seen online havnt been very ...
0
votes
0answers
20 views
Forward Engineer to SQL Server?
Are there any software like MySQL Workbench, that allows Forwarding Engineering to SQL Server?
Alternatively, considering that MySQL Workbench Forward Engineering generates the SQL script, is there a ...
0
votes
0answers
13 views
Report building software
We have a web app that uses SQL Server on the back end. We decided to add reporting capability in our app. Currently, at my suggestion, we're using SQL Server Reporting Services.
After repeated ...
0
votes
1answer
60 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 ...
0
votes
0answers
29 views
Offline REST DB
I am looking for an offline rest database so that I can provide server-side storage on my html pages without converting them to full stack server-side applications. It can be SQL or JSON based but ...
0
votes
0answers
13 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 ...
-1
votes
2answers
26 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
49 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
57 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
0answers
22 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
3answers
60 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
1answer
28 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
88 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
24 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
1answer
54 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
23 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
1answer
37 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
1answer
154 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
19 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
45 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
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
0answers
19 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
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
0answers
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
2answers
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
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 ...
1
vote
0answers
48 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
36 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
31 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
691 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
12 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
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
1answer
100 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
13 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
31 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
10 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 ...
