Questions tagged [sql]

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

Filter by
Sorted by
Tagged with
1
vote
1answer
19 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
49 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
161 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
386 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 ...
2
votes
3answers
16k views

What is the best frontend program for my database needs?

I am currently an Electrical engineer and I have been tasked to set up a database(outside my realm of expertise) that will be used by multiple users over a networked drive. There will only be a couple ...
1
vote
0answers
46 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,...
1
vote
1answer
61 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 ...
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
476 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
1answer
138 views

Light-weight SQL ETL tool compatible with Redshift

I'm looking for a light-weight SQL ETL tool compatible with Amazon Redshift. The primary (currently the only) use case would be to schedule queries that perform aggregations on Redshift tables, and ...
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-...
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, ...
3
votes
1answer
115 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
29 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
200 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, ...
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
2answers
115 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 ...
1
vote
0answers
52 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 $...
2
votes
0answers
106 views

Open Source SQL Static Code Analysis Tool

Is there an Open-source SQL lint/static code analysis tool available that lets me specify custom rules? I'm thinking of something akin to Food Critic https://acrmp.github.io/foodcritic/ which allows ...
1
vote
1answer
34 views

Is there a SQL system or wrapper that supports the actual standard as an abstraction?

I am pretty new to databases; I am currently taking an online course from Stanford about relational algebra, database design, and fundamental and advanced features of the SQL language. I am going to ...
1
vote
0answers
284 views

Tool that can create c++ structures from the tables of an SQLite database?

Given an SQLite .sql database file. Is there a tool that can automatically create C++ structures from its tables? For example, an sqlite schema in this form: CREATE TABLE [ACCOUNT] ( [ID] ...
2
votes
0answers
42 views

Database / SQL history tracking

We have an existing product which is moving out of beta and will start to roll out to a large audience now. They like the product, but we've received feedback that they need some history logging. ...
1
vote
0answers
30 views

Tool to trace and create a script of all DB writes

We have a complex process that creates various entries into a large database. I would like to generate a single SQL script that performs all the writes that are done by a single run of this process. ...
3
votes
0answers
50 views

Database schema and data management tools

I've been using Visual Paradigm on both mac and linux to simutaneously manage my database's schema and example/test data during development. I have found their interface to only get buggier over time ...
1
vote
0answers
32 views

SQL Server backup with API, automated deployment, S3

I am looking for a good SQL Server backup/restore solution. There seems to be a lot of options out there, but I specifically need these capabilities: Automated deployment. It should be easy to ...
2
votes
0answers
49 views

Simple database management tool

I have a very simple website complemented by a database (MySQL) with a couple of tables which are used in the website to render some pages. For ease of talk, this website simply lists a set of ...
1
vote
0answers
25 views

Website for comparing SQL performance

Is there a website which allows you to paste a DDL for your DB and two SQL statements, which can then recommend one (optionally including context such as; "if >10,000 rows use Query#2; else Query#1")? ...
2
votes
2answers
55 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 ...
4
votes
0answers
264 views

Which SQL engine atop Hadoop?

Since Hadoop came out, there have been various commercial and/or open-source attempts to expose some compatibility with SQL. I am seeking one which is good for low-latency querying, and supports the ...
5
votes
1answer
1k views

SQL server and client for Ubuntu (Debian) [closed]

I have been using MS IIS server and MS Sql client Management Studio at workplace on Windows system. My home system is a Ubuntu system and I like setup a database server and a client to interact with ...
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 ...
1
vote
0answers
40 views

FLOSS Dataflow generator for SQL

I'm looking for a (FLOSS) dataflow chart generator which is capable to build up flow based on a list of SQL queries thrown against the database. So something like SELECT * INTO myTable FROM oldTable;...
1
vote
0answers
115 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 ...
5
votes
2answers
4k views

Web-Based Report Builder for SQL Server

I have an online tool that stores activity data in SQL Server on the backend. I want to give my users access to that data in a controlled way, so that they can mine the data and build any type of ...
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
1answer
70 views

Database query scheduling software

I have the following scenario: A large database (postgresql). Many organizations that need to extract data from this database, each one with its own schedule and data requirements. I want an ...
1
vote
0answers
25 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
1answer
104 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.
3
votes
0answers
85 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
119 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 ...