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
2answers
24k 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 ...
4
votes
3answers
162 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 ...
4
votes
2answers
161 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 ...
9
votes
2answers
691 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 ...
3
votes
0answers
44 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 ...
3
votes
3answers
22k 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 ...
18
votes
5answers
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 ...
8
votes
5answers
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 ...
4
votes
0answers
42 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 ...
3
votes
3answers
127 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 ...
5
votes
3answers
119 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 ...
5
votes
2answers
547 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 ...
3
votes
3answers
576 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 (...
2
votes
1answer
119 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 ...
2
votes
1answer
152 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-...
1
vote
1answer
85 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) ...
1
vote
2answers
33 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 ...
5
votes
3answers
6k 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: ...