Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [sql]

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

0
votes
0answers
4 views

Sum value base on condition [migrated]

This is my first post at Stack, so please excuse me if I have any mistakes. I have a table data like this in SQL I wanna create one more column with the value is calculated base on Specific Code ...
0
votes
0answers
7 views

Which no-SQL DB would you recommend for storing financial data like user balances? [on hold]

NB: I am fairly new to coding and even 'newer' to DBs. I am trying to figure out if there is a no-SQL DB best to use in developing apps that include money transactions(like betting sites, lending/...
1
vote
0answers
11 views

Need entirely free SQL database for Mobile Application

I'm in the early stages of building a mobile app (starting with Android and then IOS). Upon opening the app I want user filters to be able to query real time into the database and load current state ...
0
votes
0answers
6 views

How to generate annual statements using python? [closed]

I came across this question """ How to develop Python programs to create anniversary and quarterly statements for an Annuity business unit? """ Please give me your opinions about generating ...
0
votes
0answers
8 views

Software for creating an app around a HeidiSQL database

I started working on a project where I created a database on HeidiSQL with a series of procedures, functions and triggers. For the next step, I need to create an app (windows or linux) that will ...
0
votes
0answers
9 views

Best tools to check SQL code

I am searching for best tools that are available in market to find anomalies in SQL code. SQL Code includes Queries, Stored procedures, Functions, etc. Expectation is to have a tool which checks the ...
0
votes
0answers
5 views

Software for visualizing database schema from existing SQLite database

Dear Stackexchange Community, my little problem looks like followed: I have an existing SQLite3 Database with 15 Tables and I am looking for a tool that automatically creates me a Visualisation of ...
1
vote
1answer
14 views

query the web by response headers and url

Do you know any service that allow you to use sql like query to find stuff on the web? I read about something like it about 2-4 months before that gather information from the world wild web but I ...
0
votes
0answers
20 views

Php free and web based reporting tool

Need help to find free and web based reporting tool for my php project. Need run it on server and create pdf/exel report based on sql/visual queries. I tried different tools but they are not good (...
0
votes
0answers
10 views

PostgreSQL query formatter which removes unnecessary parenthesis

When I ask postgres/navicat to give me the definition (DDL) of an existing view it gives a version which has way too many bells and whistles compared to what was used to create the view in the first ...
0
votes
0answers
14 views

Tool that guides converting / mapping JSON, XML, Excel based data to various SQL Table Formats

I would hope this tool would let me select columns for import from excel and then rigidly apply data type rules, allow custom conversion functions, and provide some sort of "workflow" that retains the ...
0
votes
0answers
34 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
89 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 ...
0
votes
0answers
30 views

Recomended SQL client for AWS Athena that supports queries sharing

I'm looking for the best sql client to use with AWS Athena (with JDBC driver). One of my needs is to share the queries between users, and I would like to know how can I do it in the best way. The ...
0
votes
0answers
7 views

Client side 2D and 3D creation on asp.net website

I would like to integrate a 2D and 3D floor plan designer for my customers on my asp.net website. I have looked at WebGL. Has anyone used WebGL for doing website floor plan design? Or can you ...
2
votes
2answers
42 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
0answers
22 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 ...
0
votes
0answers
15 views

Which database should I use to store time series that is local with concurrent writes and not in memory?

I am developing a stock application where I plan to view some indicators such as SMA etc. I would be getting 1000 assets every 15 minutes OHLC data which I am doing with Celery in Python (distributed ...
2
votes
1answer
30 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 ...
1
vote
0answers
12 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 ...
0
votes
0answers
25 views

MongoDB or SQL to embedded BI (for SaaS product)

This post asks a similar question, but because of stitchdata.com, I'm wanting to open the question up to SQL possibilities as well. We have a SaaS product and would like to show admins a BI dashboard ...
0
votes
0answers
22 views

Need to decide MMDB - whether Unisql, CosmsDB, MongoDB etc

We have a 3-tier application written in.net C#, sql stored procs. We have to add enhancements that will cater to the following requirements : In a museum application (it will run on Mobile Browsers), ...
1
vote
0answers
30 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 ...
1
vote
0answers
35 views

Object-Oriented SQL Representation

I am looking for a library that offers an object-oriented representation of raw SQL queries. With the example of SELECT statements, I imagine something like having an object that represents the ...
0
votes
0answers
6 views

Web control to support SQL autocomplete / typeahead

Please suggest a web control (preferably with angularJS support) that can be used to provide autocomplete/typeahead functionality for writing SQL queries.
0
votes
0answers
6 views

Trivia Seeding Gem

I'm looking for a gem like Faker Gem that has trivia categories, questions and answers so that I can seed my database with it. I'm running a Rails server with Postgres if this matters any. Anyone ...
2
votes
1answer
71 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 ...
1
vote
2answers
37 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 ...
1
vote
0answers
421 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 ...
1
vote
1answer
33 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 ...
0
votes
3answers
207 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
52 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 ...
0
votes
1answer
57 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 ...
1
vote
3answers
84 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 ...
1
vote
1answer
245 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
0answers
36 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
15 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
27 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 ...
0
votes
0answers
21 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
26 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 ...
2
votes
1answer
79 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 ...
1
vote
1answer
94 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 ...
1
vote
1answer
135 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
1answer
96 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
2answers
42 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
171 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
0answers
57 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 ...
6
votes
2answers
150 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
2answers
64 views

What gui(RDBMS) to use for MariaDB on Linux?

I recently installed MariaDB on my ArchLinux and would like to have some GUI program for me to interact with the databases more easily. I tried MySQL Workbench but it doesn't seem to connect properly ...
3
votes
1answer
49 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 ...