Skip to main content

Questions tagged [database]

Software to create, manage, or interact with databases or software related to databases. For specific databases, please use the corresponding specific tag (see wiki).

Filter by
Sorted by
Tagged with
20 votes
2 answers
25k views

Best Free Alternative to Tableau

Is there a good GNU/FOSS alternative to Tableau? Tableau is a piece of software which allows you to connect to heterogeneous data sources (files, SQL databases, etc) and quickly combine data in ...
Hack-R's user avatar
  • 619
4 votes
3 answers
203 views

Tool for database comparison

I am looking for a tool that allows me to compare two SQL Server databases, see the differences, and move the changes from one database to another. In simpler terms, I want a tool exactly like the ...
scubaFun's user avatar
  • 337
4 votes
2 answers
228 views

I need a software that will help me to create an diagram of a structure of my application

I need a software that might help me about drawing/creating something like this: That's what I've found in my faculty book, and I need to create my own diagram of structure of my application, that ...
Roxy'Pro's user avatar
  • 153
2 votes
2 answers
496 views

What beginner friendly database to store timeseries data?

I will preface this with the fact that I am entirely new to development. I've thrown together a Google Addon within a couple months, but that's about it. (Just to show you my limited experience.) I'm ...
Kuklaph's user avatar
  • 23
18 votes
5 answers
5k views

Quick and Easy Data Model Diagrams (ERD)

When I'm doing documentation, I frequently want to build a small ERD by hand to demonstrate a couple of relationships that are associated with the current topic. I can do it in Visio, and frequently ...
Steve Kallestad's user avatar
9 votes
2 answers
738 views

Tools for maintaining and deploying database schemas and data for SQL Server?

I'd like to maintain the schema and 'static' data of a SQL Server database as code in a version control system. I'd also like to be able to deploy specific versions of the database code to actual ...
Kenny Evitt's user avatar
8 votes
5 answers
7k views

OS X MySQL client?

I'd like to have a nice GUI for MySQL on OS X. The app must: Support connecting to external databases Support tunneling over SSH Show a nice GUI for editing and creating table schema Give access to a ...
user avatar
7 votes
3 answers
8k views

SQL Server client for Ubuntu

I need to connect to a MS SQL Server database from my Ubuntu machine. Any client suggested? I found libmono-entityframework-sqlserver6.0-cil, will that work? It doesn't sound like just a client: ...
Mario Trucco's user avatar
5 votes
4 answers
26k 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 ...
asloss's user avatar
  • 153
5 votes
2 answers
724 views

Recommended ETL Tool

Goal: Find a new ETL tool that shall replace Microsoft SQL Server Integration Services (SSIS). Criteria: - Open source, or free to use. No trial. - User-friendly. Information: - I use different ...
HelloWorld1's user avatar
5 votes
3 answers
133 views

Most appropriate software for data warehouse ticket tracker and encyclopedia

My university is working on a data warehouse and I was given a task to create a website (we call it "data warehouse encyclopedia, but it isn´t a widely used title"), which will have few simple ...
Martin Čejka's user avatar
5 votes
3 answers
4k views

Command line SQL formatter or beautifier

I am looking for a command line SQL formatter = SQL prettifier = SQL beautifier (offline, not an online formatter) for Mac. The goal is to run it on the command line and also inside the editor (Emacs) ...
Timur Shtatland's user avatar
4 votes
0 answers
50 views

Any smart database schema comparison tools?

I need a tool which can receive the schemas of a master and a target databases (generated by a tool e.g. mysqldump -d --routines --triggers --events) and generates an update script to update the ...
Real Dreams's user avatar
4 votes
3 answers
247 views

In-memory database for streaming market data

I'm looking for recommendations for an in-memory database for capturing streaming market data state. While the transaction rate may reach into millions/sec, most of these transactions will be updates ...
sevzas's user avatar
  • 141
3 votes
1 answer
464 views

Linux CLI tool for auto-formatting (pretty printing) large SQL files

I have a large (3 GB) SQL file that came from a SQL dump. Reading it is impossible because it's formatted poorly. For example each table has a giant INSERT statement that is indecipherable. Is there ...
Freedom_Ben's user avatar
3 votes
0 answers
60 views

Chat history database

I frequently use chat and similar means of communication with friends, teammates and other people. But I use a variety of programs and sites to do so, like Skype, Whatsapp, a few social networks, SMSs ...
Alejandro's user avatar
  • 740
2 votes
1 answer
246 views

Good way to store data hierarchically?

I'm looking for a way to create a tree (data structure) of places to visit in life. I would like to have hierarchy like this Continent I- Country I- Region I- Sight to visit I-...
CHfish's user avatar
  • 143
2 votes
1 answer
146 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 ...
Trevor Boyd Smith's user avatar
2 votes
3 answers
609 views

SQL Server/Oracle/MySQL database tool for developers (DDL Manipulation, stored procedures, triggers, OLEDB, ADO.NET)

I'm looking for a Database tool for developers with the following features: SQL querying Can be connected to SQL Server, Oracle and MySQL. Can run on Windows and Linux distros DDL Manipulation (...
morgano's user avatar
  • 233
1 vote
0 answers
16 views

Free skills/qualifications database

I'm not sure if this is the correct place to ask this kind of question but I'm looking for a freely available, free of charge (or at least not expensive) database with list of skills/qualifications a ...
Łukasz Grabski's user avatar
1 vote
1 answer
108 views

Visual database design tool for MySQL 4.*

I am looking for a visual database design tool that: integrates SQL development can browse databases and tables graphically supports the connection method TCP/IP over SSH (like MySQL Workbench) ...
Franck Dernoncourt's user avatar
1 vote
2 answers
49 views

Software to merge CSV files with true/false columns if entry is present

I have multiple separate CSV files that are just a single column list of email addresses, where each file represents a 'tag' associated with that email. I'd like to merge them into one CSV file, such ...
Benny Lewis's user avatar