Questions tagged [sql]

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

Filter by
Sorted by
Tagged with
1
vote
0answers
123 views

Open-Source Web application for creating forms to query a database

What I imagine is a tool on which you can select your SQL database (ideally any of the RDBMS but if it is limited preferably PostgreSQL). In said tool administrator can create query and result forms ...
1
vote
0answers
52 views

Are there software packages that help create front-ends to SQL/RDBMS databases which can be completely customized?

I have an idea for a website where I want to build a database of items that a user can view, filter, and sort through but not alter the data. On the backend, I would want to be able to add data, ...
1
vote
0answers
26 views

Free/open-source lib for .NET to interpret SQL-like filter clause

We'd like to provide our users with the ability to enter filter expressions like "x > 10" or "(x IN ('A', 'B', 'D')) OR (x = 'Z')" and then test whether a string matches the user filter expression. ...
0
votes
3answers
333 views

Is there alternative to SQL Developer that supports PL/SQL too?

I found Oracle's SQL Developer hard to setup, so I would like to use something easier, but with support of the same language or maximally close, preferably free (GNU) and preferably available for ...
0
votes
2answers
56 views

Is there any free data modeling software that exports the schema to a machine readable format other than SQL?

I am in the process of mapping my country's open data, and the relationships between them, and I need to do it in both human and machine readable formats. I am looking at diagramming tools for the ...
0
votes
1answer
215 views

MS SQL client providing read-only mode

I have a MS SQL database with some very, very sensitive data. If anything gets broken, half of the planet will fall into chaos. Almost :-). I have a database user with some restricted permissions, ...
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 ...
0
votes
1answer
14 views

Is there a tool to view entity relations from a sql script?

I have a sql file with a long list of create tables and alter tables. Is there a tool available to look at the entity relationships that result from running the sql script. It would be great to not ...
0
votes
2answers
17 views

I need some free softwares to make c# application setup with database

I have created a c# windows application which is simple and has simple sql database, I use SSMS to manage my database, but now is time to create a setup because I want my app to be ready to use for my ...
0
votes
1answer
19 views

syncing code across multiple computers

I'm looking at ways to sync my code across computers, so it can be used and edited on either. I currently code in: R python sql developer What would be the best way to do this. I was looking at ...
0
votes
2answers
44 views

Creating a Simple Database with UI on Local Machine

I am looking to create a small database (no more than 6 tables with less than 10000 records) which can be accessed from a front end GUI which will present records to the user along with forms to ...
0
votes
3answers
51 views

Software for creating Win-Applications

I have been looking for a software solution for writing Windows applications with GUI in which I can access MS-ACCESS and SQL databases. I would prefer C#. However, I'm just looking for free ...
0
votes
1answer
102 views

Update Power Point slides from SQL data in real time

I am wondering if there is any simple program available to allow me update slide show made in power point to control or update display slides while it is running, maybe using separate program with ...
0
votes
1answer
113 views

Reporting tools when using SQL server management

Here's my context : We are found of SSRS (SQL server reporting services) with visual studio 2008 But the more we use it, the more we see limitations, and bug, and non-implemented feature, and ...
0
votes
1answer
219 views

Scalable RDBMS alternative, NoSQL, NewSQL

I am looking for scalable alternative to traditional DBMS like PostgreSQL or MySQL. In traditional databases I don't have the following features: Auto sharding to ensure linear scalability. ...
0
votes
1answer
114 views

Datebase-comparing tool that supports schema and data

I'm looking for a tool which is able to compare schema as well as data of a database. Ideally for some Sybase SQLAnywhere. All what I've found was only for schema.
0
votes
0answers
8 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
4 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 ...
0
votes
0answers
11 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 ...
0
votes
0answers
7 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"...
0
votes
0answers
15 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 ...
0
votes
0answers
19 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, ...
0
votes
0answers
5 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 ...
0
votes
0answers
8 views

Documenting stored procedures

I'm searching for a SQL script or a freeware to document stored procedures batch, from the point of entry to tables and depending stored procedures. It should analyse all stored procedures regarding ...
0
votes
0answers
11 views

Convert SQL query to graphic model

I am looking at complex SQL statements and wondered if there's a free tool (online, python library...) which can represent the query into a graphical model. For example: You have a select query ...
0
votes
0answers
17 views

Whats my next database setup?

Currently I am running a windows server with sql server - and SSMS. But I am a bit tired of windows and ms - love the sql server and ssms though. My desktop is running linux mint, so I remote ...
0
votes
0answers
14 views

SQL SERVER performance OPEN SOURCE monitoring

I'm searching for good open-source solution to monitoring SQL SERVER performance, It will be nice if it has a web client. I have 32 SQL SERVER instances and 11 Windows Servers, I want to collect data ...
0
votes
0answers
5 views

Creating an excel arc that communicates with SQL

I have a website that stores orders. Foreach order, there is(should be created) an excel arc, where some of the fields should be filled by me, and the rest should be filled by the customer. The ...
0
votes
0answers
11 views

Which SQL Server Standard version will run on Windows 7 Embedded?

I want to load Microsoft SQL Server Standard on Windows 7 Embedded but don't know which versions (2012,2014, etc...) of Standard can run on Windows 7 Embedded. I would like to use CALs instead of ...
0
votes
0answers
7 views

Is there a software (like OpsGenie) that will show whether or not stored procedures have run on Microsoft SQL Server?

I'm looking for a web app (or something similar) that is able to show super simple statuses of stored procedures (or groups of stored procedures) similar to the way OpsGenie works. All I want it to do ...
0
votes
0answers
6 views

Is there a free software that lets me send commands if there is data in a SQL view

Is there a free software (could be a service too) that detects when there is data in a certain MS SQL view, and then can trigger a custom command to a certain server on a certain port? I am trying to ...
0
votes
0answers
15 views

Tool to create documentation from a SQL query

At my company we have a project where we write select SQL queries on different financial software databases to insert into a pre-designed database table we created. An example query would be: ...
0
votes
1answer
22 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
9 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 ...
0
votes
0answers
8 views

Scraping Wikipedia to build a database of musicians and their hometown/origin

I have to scrape Wikipedia to create a SQL database of musicians and producers along with their hometown or origin. What are some tools/programs I can use? Thanks so much!
0
votes
0answers
12 views

OLTP or OLAP for Batched Transactions

Which database paradigm should I leverage to support a Relational Database, which is updated as a weekly batch, and which supports typical analytics query-patterns. From the RDBMS-side I need to ...
0
votes
0answers
4 views

What's your software/framework recommendations for building a CRUD application in java in a smart way

our firm develops softwares for business which mostly has CRUD (Create, Read, Update, Delete) functions. The software is quite big and provides several features to handle their data. And the data is ...
0
votes
0answers
3 views

Do we have any package/library to read excel files in Oracle 12 and above?

I need a suggestion on how to read excel files in oracle. Is there any library/package that simplifies the work.
0
votes
0answers
4 views

( Angular 2 [V.8] + ASP NET + SQL ) Need a search engine/plugin that is going to work like Stack exchange's related questions query or elastisearch

So I'm building an application for my organization that, just like Stack Exchange when you ask a question it searches the for similar / related questions. I am using Angular 2 on the front end and ASP ...
0
votes
0answers
15 views

Help developing a golf score tracking mobile application

I, along with three other people, are assigned a project for our upper-level college course. We are responsible for creating a mobile application for our schools golf team. Here are the specifications ...
0
votes
0answers
5 views

Tool to manage (sql) queries

I'm looking for a tool that will allow us to manage (create, update, delete) queries in an online platform and that is accessible via an API. Some context, we have lots of queries that are ...
0
votes
0answers
6 views

Simple Python Web App to Display Result Sets from Different SQL and MySQL DB w/ Multi Connections

I have system metrics stored in SQL and MySQL tables on a few different connections. I want to display these as a helpful Systems Monitor UI for those on the network that they can access through their ...
0
votes
0answers
10 views

Need to move 200+ tables from OData source to a SQL database

I have an OData URL with 200+ tables and I need to create all the tables in a SQL database and copy data daily to the SQL database. An additional requirement is to be able to easily change the ...
0
votes
0answers
10 views

Which environment to use for SQL

I'm not quite sure how to google this question, as I keep getting mixed results. I have a set of data I want to work with. I have a function that pulls the correct data that uses MySQL 5.7 (I ...
0
votes
0answers
27 views

Looking for a SQL result exporter tool for non-tech end users

Six years ago we built a homemade tool for our internal users to download CSV files based on a SQL query. There is two kind of users : Admins who can define a SQL query with parameters Users who can ...
0
votes
0answers
13 views

RStudio or SQL for data cleaning

I am wanting to detect corrupt and inaccurate records to check for data quality from large data sets that originate from Microsoft Access and Excel. Things I would like to check for: Validity which ...
0
votes
1answer
28 views

Report distribution tool

we are looking for a SW/tool which would help us to automate the reports distribution. We use MS SQL Server 2016 and SSRS (Sql server Reporting Services), we have a knowledge of SQL coding. Our ...
0
votes
0answers
55 views

generate and validate an SQL query on Angular 6 UI

I have a requirement to generate and syntactically validate an SQL query on Angular 6 UI. Any recommendations for any libraries/plugins which are available and easy to use would be appreciated.
0
votes
1answer
16 views

Visual Studio 2017 Enterprise C++ Connect to to Postgressql Server

What is the best way to connect from C++ to a postgressql server? An important limitation is that there can't be any additional software installations (some .exe or .misi files that install the driver)...
0
votes
1answer
23 views

Best option/opinion on how to load website data - Html/PHP into a SQL Server Database?

I have been thinking and trying to expand my knowledge of different tools. One thing I have never had personal experience with is getting website data that users enter, and have that loaded into a SQL ...