Questions tagged [sql]

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

Filter by
Sorted by
Tagged with
0
votes
0answers
38 views

Looking for a database server on an embedded system

So I'm looking for a database server which needs to run with the following requirements: Run on Windows XP. Log in via TCP/IP. Authentication. Expose custom stored procedures. It will be running on ...
3
votes
2answers
783 views

What DB engine should be used for a petabyte database?

Given: The volume of data is expected to run into petabytes over a couple of years. The full set of record types, applications and queries is not known in advance. It is expected that stakeholders ...
4
votes
4answers
3k views

Tool to compare the results of an SQL query on two databases

I am looking for a tool that allows me to compare data from two SQL queries on different databases and see the rows that are different. Both databases are on MS SQL server. I have looked at following ...
2
votes
2answers
48 views

What kind of front end should I use?

I'm an intern at an electric company and I've been tasked with producing a front end web app with display and input capabilities. What they want to be able to do is put something like this into a ...
2
votes
1answer
42 views

What is the best spreadsheet-like tool to manage structured data with tags and multiple columns of different sizes

I'm trying to find a tool which can fit my needs in the management of a list a scientific papers I read during my phd thesis. For each paper I collect title, authors, write a summary, give tags... I ...
4
votes
0answers
51 views

Excel to SQL mapping tool

I am looking for a tool/library to import data from different clients into our SQL database. Each client will have their own EXCEL file. So the number of columns, name of the columns in EXCEL would be ...
1
vote
0answers
26 views

Free Database ERD Creator

I am looking for a free option that I can use to design my databases. The following features are a must: Needs to be free or under $100 Able to generate SQL statements to generate the completed ...
1
vote
0answers
32 views

Very fast in-memory SQL server

I have an ETL problem that's small enough to live in memory but complex enough to be managed by a team of SQL devs. What's the best way to get very fast standard-compliant SQL where concurrency isn't ...
0
votes
1answer
212 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. ...
1
vote
1answer
389 views

PHP Business Intelligence - alternative to metabase.com

I am searching for an openSource self hosted Business Intelligence Tool. As sonamor pointed out here, The project metabase.com ist actually very good suited BUT - it is build on JAVA/clojure and I can'...
1
vote
2answers
43 views

Where to create SQL databases online?

I am wanting to create my own online SQL database for a website that is going to feature some interactive r shiny/plotly apps. I see that there a appear to be a few options through things like amazon ...
2
votes
1answer
131 views

Faster alternative to Microsoft Access for simple ad-hoc queries

Sometimes I use MS Access 2017 to perform database tasks: Union, Filter, Join ... From time to time I receive data which I need to process, these are different, short, ad-hoc tasks, I need a tool ...
2
votes
1answer
73 views

Test data generator for MySQL

I want a tool for populating a MySQL database with random data. The data generated for the primary and secondary keys should be coherent, so the data will not cause integrity errors. It should ...
2
votes
3answers
96 views

Software to produce graph, chart, table from an SQL query

I'm looking for a software that is capable of connecting to a MSSQL server, execute queries and produce graph, chart or table based on the result returned. I understand that Reporting Server is able ...
0
votes
1answer
97 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 ...
2
votes
0answers
670 views

SQL Input Sanitization Library

I'm working with a third-party API that requires me to give it complete, runnable SQL query text - I cannot use approaches such as parameterization in order to guard against input that may break a SQL ...
0
votes
3answers
328 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 ...
-1
votes
1answer
59 views

which database is better for my case? sql? nosql? newsql?

right now i have project which is about gathering information about country wide real estate active dealers and etc. the goal is to create an information system for real estate activists, the data ...
2
votes
1answer
116 views

What is a good Python module to access data in a MySQL/MariaDB database?

I need to process a bunch of rows from a MySQL database table. I will be using Python as the programming language. Requirements: Python module reading the rows of an existing database/table data is ...
6
votes
2answers
172 views

Graphical SQL client

I have always used MySQL (or MariaDB, which is essentially the same thing) from the native command-line interface, which works fine. But I've recently started needing simultaneous access to both MySQL ...
1
vote
1answer
31 views

SQL managing software to manage/edit querys

I've got a database I need to migrate to a new format. Now I have lots of data and I need some help in changing the queries to the format the new database accepts. Does someone know software to manage ...
1
vote
0answers
39 views

SQL-like graphical software for entering, creating and displaying many to many tables

I am looking for something like a GUI on top of SQL. My use case is trying to record and manage a list of servers, workflows that run on those servers, software licenses that are associated to those ...
1
vote
0answers
17 views

Middleware / interserver communication tool

I'm looking for an engine to store key / value pairs to transfer data between servers. The goal is to have a server write these values to the database and then not be able to retrieve them. Another ...
1
vote
1answer
123 views

tools to create SQL queries through a graphical interface

I'm looking for a tool other than Access that can create SQL queries, through a graphical interface. This is what I'm trying to do Adding some details, my database is on Postgres and I'm using the ...
0
votes
0answers
22 views

Which front end SQL client should I use with a Windows front end configured to a Postgresql back end?

I want it to be open source and runs on Windows. I have a Linux server running Postgres. Which free application is versatile, easy-to-use and secure? TOAD is not free. There are other open-source ...
1
vote
0answers
33 views

How to execute type save sql queries with C#? or Looking for SQL wrapping API for C#

Instead of executing sql queries with plain query Strings I would like to use some kind of builder pattern to be able to execute type save sql queries in C#. In other words I am looking for an SQL ...
0
votes
1answer
112 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 ...
1
vote
1answer
459 views

Check for duplicate column names in an SQL query

I have a rather long SQL (MySQL flavor) query and want to check if different fields queries have the same name (or alias) like SELECT a, a .... Any software for this? I use Linux.
0
votes
2answers
55 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 ...
2
votes
3answers
3k views

Reporting tool/framework/library for .Net

I want to print pdf reports with lots of charts and text on demand. I have some sub reports, which can be generated stand-alone and can also be merged to generate a single master report. Right now, ...
1
vote
0answers
65 views

Is there a terminal-only version of a SQL query editor like Sequel Pro?

I'd like to be able to do everything I can do in Sequel Pro but via a terminal interface. It should be more powerful than the MySQL cli that is just a REPL. I'd like to be able to stage queries and ...
3
votes
1answer
54 views

I need a GUI that will edit a TEXT column in MySQL

I normally use MySql Workbench. But I now have a table that has a column of type TEXT. It is used to store Python script for use in Jython. Some of these scripts can be quite large. Workbench only ...
1
vote
1answer
72 views

SQL Data verification framework?

I receive a variety of flat files that need to be transformed and aggregated in several stages of a custom ETL process before loading it into a SQL Server database. After each stage, I'd like to ...
1
vote
1answer
20 views

SQL table handler without server/client

I am looking for a CLI program for Ubuntu 14.04 that will be able to use a file as a "database". I really don't get why every piece software I found so far has a "daemon" and a "client" part, when ...
1
vote
0answers
51 views

Type of Database for Live Streaming

I begin with a project about videostreaming with Android, specifically Live Streaming (not video on demand) The device Android will transmit video and audio, too I will have other software in desktop ...
3
votes
2answers
175 views

Tool to generate SQL database update scripts

I'm looking for a tool or an open-source project that can generate database update scripts in the following way: Accept a database connection string as a config parameter Connect to the specified DB ...
1
vote
0answers
403 views

SQL query simplifier tool

I need a tool to simplify queries like: select usertourna0_.id as id64_0_, usertourna0_.timestamp as timestamp64_0_ from some_table_name usertourna0_ where usertourna0_.id=:p0 and not (1=0) order by ...
1
vote
0answers
47 views

No Coding Required Database Management Tool (CRM?) Equivalent to Microsoft Access

I'm looking for software where I can manage a database created from excel/Google sheets. Ideally, I'd like to import the documents into the SQL database. I have experience in SQL so set it up, however,...
0
votes
0answers
17 views

Converting create table statements from Oracle SQL to PostgreSQL

I am looking for a program that can converting create table statements from Oracle SQL to PostgreSQL (e.g., choose the closest type for each column). Any OS, any license, any price is fine. CLI or ...
1
vote
0answers
542 views

Programmatically build SQL queries in Java

We have a query that needs to be built dynamically when the user chooses search params in our GUI. I understand how to do this by hand in SQL by appending strings. While this does work there are a ...
1
vote
0answers
16 views

Open source SQL database with BASE semantics?

Basically I'm looking for an Open-Source (or free) RDBMS with a SQL-like interface that is highly concurrent. Some features I'm looking for: A rigid schema defined at "compile-time" A production-...
3
votes
0answers
89 views

Free tool that can execute large SQL scripts

I have a SQL script that is too large to run it in my usual DB tool (dbvisualizer). Unfortunately I don't have access to the purchase version of dbvisualizer which would allow me to run large scripts ...
7
votes
2answers
120 views

Software reformating SQL statements

I'm looking for an easy tool which is helping to reformat SQL statements. So e.g. SELECT foo, baa from baafoo where id > 10 and comment = 'John was it'; will become to something like SELECT ...
4
votes
1answer
130 views

Free SQL test data generator

I'm searching for a tool to generate SQL test data. What I'm looking for exactly should Be gratis Generate test data from Regex Be compatible with Microsoft SQL Server (compatibility with MySQL and ...
0
votes
0answers
30 views

Compare script output from remote server with local result

I want to run this SQL on the local and remote host: select concat_ws('.', table_schema, table_name, column_name) as column_name from information_schema.columns where table_schema not in ('...
0
votes
1answer
213 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, ...
1
vote
2answers
60 views

Styled Data-Driven Reports for Print

I work at a school district and am helping to put together a project that will keep kids on track for graduation. We are able to flag a certain number of kids in our database who we can see are ...
1
vote
2answers
172 views

Software to use as front-end for a SQL database?

I am looking for an alternative to MS Access. A simple tool that you can design a front-end for the user to be able to connect to database and enter data. Background; currently I am using Access as ...
2
votes
0answers
31 views

Comparison/Review Website Software

I am looking for website software (preferably open source), written in either PHP or ASP.net, where users can login and review a certain place and compare it against others in the area. Does anyone ...
1
vote
0answers
53 views

Java command line SQL interface

I want a good console SQL Client written in Java that I can use third party jdbc drivers, specifically jt400.jar with. I'd like autocompletion, history. and the ability to edit the current query with $...