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
36
votes
7answers
26k views

Free software to reverse engineer existing complex database diagrams in SQL Server 2008+

Up until a few years ago I used Microsoft Visio to reverse engineer an existing database to a diagram. This feature has been deprecated for a while now, and I'm rather stuck in finding an alternative. ...
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 ...
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 ...
18
votes
2answers
12k views

MySQL client for iOS?

I'd like to be able to manage my MySQL databases from my iPad. I currently use Sequel Pro on my Mac, and I love it. The app must Support connecting to remote databases Support tunneling over SSH ...
16
votes
5answers
1k views

MongoDB database administration GUI

Please suggest a good GUI-based tool for MongoDB database administration. Requirements: Connect to DB on local or network server. Data view and editing features. Free or Open Source Support Indexing ...
15
votes
1answer
1k views

“End user friendly” database tool (e.g., for curating a personal collection)

I’m looking for a graphical tool that allows me to create, populate and browse/search databases. Primary use case: Curate a personal collection (e.g., for movies, postage stamps, quotes, …). There ...
13
votes
1answer
554 views

Which database should I use? Locally stored, about 20 writes per minute, 1 read per minute, will grow 15MB each day

I'm building a self-tracking system to log e.g. my phone's accelerometer, the keys I type, my mouse activity, and so on. So which database should I use? My research so far suggests SQLite3, because ...
13
votes
2answers
212 views

HR performance management system

I am looking for software similar to workday or successfactors for HR performance management system. But the examples I mentioned are a bit expensive. The main purpose of the software is to monitor ...
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 ...
9
votes
1answer
507 views

General purpose database application alternatives for iOS and Mac

I am looking for a way to manage inventory in the field. I want to use an ipad/iphone for taking inventory, and use a mac to generate reports. This can be a single app or a pair of apps. I can do ...
8
votes
6answers
13k views

A simple Java database library?

I'm looking for a library to manage a "database" in my Java application. I want something simple, and easy to use. Specifically, I'm looking for something which: Is easy to start using. I'd like to ...
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 ...
8
votes
2answers
781 views

Database for large volume of metrics (key, value, timestamp)

I'm looking for a Database for large amounts of metrics, and i'm confused that there is nothing out there to: store large amounts (terrabytes) of metrics data in the form: key (string) value (...
8
votes
2answers
304 views

Free software to track movies I'm watching

I am looking for either a web app or installable program that will track the movies I have watched. I have found a few online but I would like one that also tracks how many times I have watched each ...
8
votes
0answers
157 views

License management software (Open Source)

I’m trying to find a solution for keeping our license information in our database. Let’s say a customer bought something 5 years ago, so I will create a new cutomer and assign him the license he ...
7
votes
1answer
396 views

General-purpose, open-source, GUI relational database management application

I'm looking for a general-purpose, open-source, graphical user interface database management and manipulation application for Linux. I've been using Navicat Premium Essentials on my Mac, and am in ...
7
votes
3answers
6k views

Database for storing large sets of data from web scraping

I am designing a scraping system that will scrape large set of data from websites. The system is expected to collect data from websites and store it to database. I am storing structured data parsed ...
7
votes
2answers
859 views

multi-user photo/picture manager/organizer/database software

I work at an organization that makes extensive use of photography and we need an better way to organize all our photos. We have several staff and volunteers who take photos regularly. Then we use ...
7
votes
1answer
170 views

A Database Management System that understands Relational Algebra Queries

I am a Computer Science student and we are currently learning Relational Algebra. I wish to be able to write Relational Algebra Queries and test to see what they return. Thus, I am looking for a ...
6
votes
1answer
222 views

Shared contact database software

I'm looking for a way of sharing a database of contacts amongst a group of not-very-tech-savvy staff & volunteers in a non-profit. The setup and storage of data can be technical/complex as a one-...
6
votes
4answers
2k views

PostgreSQL front end for adding, viewing and updating values

In the scope of a small community project we were compelled to create a database in order to manage our events, the participating members, their contact details and so on. I've created a PostgreSQL DB ...
6
votes
2answers
2k views

Simple WYSIWGY CRUD web frontend for a database

It should be open source, deployable with MySQL/Postgres (or maybe some nosql thing); It should support CRUD using web forms; Layout of those forms should be configurable by administrator in the ...
6
votes
2answers
400 views

Which RDBMS should I use for a chat application?

I'm developing a chat project (server/client), so I will need an RDBMS for saving and loading user profiles, users logging-in etc., just like Skype does. So my question is: which RDBMS will fit my ...
5
votes
3answers
1k views

Software tool to create/modify/view table relationships in SQLite database

I would like to have a software tool to create/modify/view table relationships in a SQLite database in a visual way, something like the picture below. For a MySQL database, I can use the MySQL ...
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 ...
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: ...
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
1answer
278 views

COTS or OS reporting tools for Oracle?

I work for an organization that has a relatively massive Oracle 11g database. We currently invest a lot of time in producing custom reports - the queries are quite complex and not something to be ...
5
votes
2answers
1k views

UML to Java and Hibernate

I want to design my UML diagrams in a program, and have the program generate Java classes and Hibernate mappings. Java to UML generator on Linux is similar but does not fulfill all my requirements. ...
5
votes
1answer
146 views

PHP/Java/C++ frameworks for declarative SQL to REST API binding

What libraries/frameworks, if any, exist to bind/"scaffold" SQL relational databases to a RESTful API in a declarative manner? In short, by specifying the names of the tables and fields (alongside ...
5
votes
1answer
1k views

Easy, Automatic REST API for a SQL (MySQL, PostgreSQL, etc) Database or DaaS

I need REST API access to my SQL database for end user queries in a mobile application. I am trying to avoid having to program my own REST API because I come from a statistical programming (R, SAS, ...
5
votes
2answers
159 views

Good data entry and management systems

I am a PhD student and am thinking ahead to when I start up a psychology lab---what are some of the best data entry and management systems? To avoid the "it depends" answer, below I list what I'm ...
5
votes
1answer
107 views

Suitable product for job management

A group at my work are looking for software to help with job management in the workplace. The work environment is a laboratory and flows roughly as follows: items come in items may require one or ...
5
votes
0answers
72 views

How to centralize, store and analyse spread out file logs?

TLDR: Our application generates file logs holding bits of information that we'd like to parse them and store in one place, in order to periodically consult them and compute metrics from them (in real ...
5
votes
0answers
81 views

Local Development Databases

Currently, I work in a company with about 20 developers, give or take a few, and am looking for a way to give each developer their own development database for dev/testing purposes. Each developers ...
5
votes
0answers
242 views

In-app triplestore like SQLite

Is there any open-source and cross-platform triplestore that could be integrated into a C++ application? I’m not looking for servers (i.e. 4store or Soprano). The good example for relational ...
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 ...
4
votes
1answer
738 views

Free lightweight database program

I need a smallish lightweight and free database program to keep track of items in a large collection. I don't need it to be able to do much besides being able to create entries with various fields ...
4
votes
2answers
110 views

Scanning Handwritten Notes and Creating a Database

I'm looking for software capable of creating a searchable database from scanned files (probably PDFs but the file type isn't important) so that I can categorize and search all of my handwritten ...
4
votes
1answer
128 views

Database/Scripting Language suggestion for a project involving heavy inserts? [closed]

I am looking into a project which involves large number of inserts daily.I will have a list of user's (for example a user set of 500k ) , for which I need to monitor daily certain activities ...
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
70 views

Store and run queries on political, economic, demographical, ++ country data

I'm looking to develop an analytics tool of economic, political, demographical, and geographical data on African states. The idea is to be able to: store country data ask one question for many ...
4
votes
1answer
93 views

Customer management database

I work in a small company that gets around 600 new contacts every year (via email or contact forms). Right now, we are keeping all contacts information in an Excel sheet that we share on Dropbox, ...
4
votes
2answers
125 views

Configurable barcode reading app

At our school, we want to make our own attendance application. We would like the teacher to have an app that can read a barcode (from student id card) and send the result to a web server, where we put ...
4
votes
2answers
94 views

Database software recommendation [closed]

We are a small construction company that currently has a very old, outdated database system that has been written over the past 20 years in Visual FoxPro. I have now been designated with the task of ...
4
votes
1answer
64 views

GUI MySQL program

I am looking for a relatively basic way to browse a MySQL database. I need to be able to connect to a remote database located at x.y.com. I am using Ubuntu 14.04 and am able to connect via terminal ...
4
votes
1answer
77 views

Database technology recomendation for simulator

Alright so I am developing a simulation application and I need to know what database is advisable (Or the pro's con's of some options). tl;dr: C# application Only the application will be using it ...
4
votes
2answers
96 views

Query conversion application between SQL databases

I'm looking for an application that can convert queries, schemas, etc from one SQL-like database (e.g. MySQL) to another (e.g. Oracle). It must be able to support conversion of pretty much everything (...
4
votes
2answers
230 views

Free cross-database editing software

Is there a free software that allows to edit database ER diagrams and export for different SQL database systems (e.g. MySQL, Oracle, SQLite, Microsoft SQL Server, etc.)?
4
votes
1answer
280 views

Mac capable Access similar database software

How do I create a database application that satisfies these requirements? It must be capable of running on windows and mac operating systems. It must be similar visually to excel. The user needs to ...

1
2 3 4 5
12