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
166 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
169 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
696 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
3answers
23k 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 ...
3
votes
0answers
45 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 ...
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
131 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
120 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
568 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
165 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-...
2
votes
1answer
120 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
86 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
34 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
7k 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: ...
1
vote
0answers
12 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 ...
1
vote
0answers
19 views

Looking for script or software to pull from REST API and dump result into database

I'm working on a program that takes data from a bunch of different REST APIs and dumps their responses in a database every n minutes. Basically creating a historical data warehouse of the API data. ...