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).
623
questions
4
votes
0
answers
274
views
Which SQL engine atop Hadoop?
Since Hadoop came out, there have been various commercial and/or open-source attempts to expose some compatibility with SQL.
I am seeking one which is good for low-latency querying, and supports the ...
1
vote
1
answer
279
views
Synchronize databases in .NET
I develop an application with .NET that uses a MS SQL-Server database for storing. I can also work offline with a local copy of the Data (using MS LocalDB).
Now I want to synchronize the data when ...
3
votes
1
answer
2k
views
Convert .mbox files to .sql
I am looking for a program that can convert .mbox files to .sql (or directly insert .mbox data into some database). It should run on Windows or Linux.
If possible:
Gratis
Open source
can handle ...
1
vote
0
answers
39
views
Generic record/observation log entry management software
I'm looking for a software that would allow following functionality:
Create a record of an observed event (say, an HR-manager files info about an interview with an applicant he's just interviewed). ...
4
votes
3
answers
242
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 ...
1
vote
0
answers
170
views
Open-Source Web application for creating forms to query a database
What I imagine is a tool on which you can select your SQL database (ideally any of the RDBMS but if it is limited preferably PostgreSQL). In said tool administrator can create query and result forms ...
2
votes
2
answers
230
views
Multi-site small business data entry and billing software
Trying to find a better solution for your data and billing process.
Right now we use Excel to enter our customer information at 5 sites around the city. The files are saved to a NAS. At the middle ...
3
votes
0
answers
80
views
CMS or other web-tool with deep SQL/Database features for storing large amounts of tabular data
For examples of types of software that resembles a solution, look towards the bottom of this page.
I'm looking for a self-hosted CMS/CMF/SQL Interface or other web-tool with a WUI/GUI that provides ...
2
votes
2
answers
2k
views
OS frontend for MySQL with forms and subforms in particular
Using MySQL (in fact MariaDB) as backend, I want to design a user-friendly front-end – ideally using an HTML server. Something very much resembling the MS Access forms and subforms of old. You can ...
1
vote
0
answers
56
views
Package for accessing Cassandra database in R
I have tried RCassandra and RJDBC but unfortunately it seems that these bindings work only with the old Cassandra 1.x. Is there any binding for Cassandra 2.x in R language?
1
vote
0
answers
31
views
Is there a tool/jar/library/plugin which dumps riemann.io state (index) continuously into cassandra?
I'm trying to implement myself some kind of riemann HA so before writing a library which persists its state into cassandra, i wanted to know if there already exist's such a library / plugin to riemann....
1
vote
0
answers
54
views
Are there software packages that help create front-ends to SQL/RDBMS databases which can be completely customized?
I have an idea for a website where I want to build a database of items that a user can view, filter, and sort through but not alter the data. On the backend, I would want to be able to add data, ...
1
vote
2
answers
47
views
What would be the recommended Java database model in this case?
I have written an app that processes a video (720*576 px, 30 fps, RGB format) using OpenCV under Java. I only calculate 5 int variables as a result of my processing on each frame. I would like to ...
2
votes
0
answers
47
views
Need help to identify a proper DBMS system for stand alone software system [closed]
I am a final year IT student and I need to do a project to finish the degree.
I have a an idea about account management system for a local store. This system simplifies manipulation of day books and ...
2
votes
1
answer
2k
views
Searchable database of pictures
I need either a Windows or Mac based program that will create a database of images that are searchable. The images can be tagged but will need to be searchable by person's name, year or month or a ...
1
vote
1
answer
104
views
Database query scheduling software
I have the following scenario:
A large database (postgresql).
Many organizations that need to extract data from this database, each one with its own schedule and data requirements.
I want an ...
2
votes
1
answer
55
views
Public projects database
I am looking for server side web software, preferably written in PHP and open source, that can help me achieve the following:
Provide a database of "projects"
Which can scale up to several thousands ...
2
votes
1
answer
355
views
Hosted web platform for a small database application (back- and front-end)
I'm looking for a hosted database solution that allows you to define both the back-end (tables, views, relationships) as well as the front-end (forms, reports, ...).
Both the number of tables as well ...
4
votes
1
answer
116
views
Generate MySQL documentation
In Netbeans, if I place comments above all my methods:
and then right click on my project and click generate Javadoc:
What gets generated is an HTML document containing the API with the method ...
2
votes
0
answers
205
views
What is a fine MySQL class for Python?
I am new to python,earlier I used to develop in PHP.
With PHP, I used MySQL as the back end Database.There I had different libraries,MySQL classes with easy to use functions available open , also we ...
5
votes
2
answers
180
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 ...
2
votes
1
answer
146
views
Store GPS information in database
I need to continuously collect the location details of our users (say around 100K, at a frequency of 10 sec). What I am interested in is list of users near a particular location (i.e., I don't usually ...
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)
...
3
votes
2
answers
89
views
Database for searching lots of plain data
I currently use MySQL and Sphinx to manage a pretty basic database containing nearly 350,000,000 records. It is expected to hit a billion records in less than 200 days (anywhere from 2000 to 5000 ...
1
vote
0
answers
38
views
OpenStreetMap data editor for postgis database data/osm2pgsql result
Is there an editor for OSM data which allows direct read and write to a PostGIS database taking advantage of its features for performance?
Background: I've been checking on OSM data editor and found ...
2
votes
0
answers
25
views
Suggested lightweight key-value store for distributing state between many hosts
I'm looking for key-val store that will be used to share some state between multiple hosts.
Goal:
- Achive high availability for limited set of data, that need to be accesible on every host/node
...
0
votes
1
answer
201
views
Random text generator
I have a very simple program/piece of software in mind, but I don't know if it exists or - if it does - how to search for it.
I see this being used as a tool for creative writing or improv exercises ...
7
votes
1
answer
450
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 ...
3
votes
1
answer
187
views
Looking for an "advanced outliner"-type of software
Let me first say I've been through lots of CMS, DMS, and a few Wiki's and Outliners.
The closest three programs I've found that resembles the kind of product I'm looking for are:
Tiki Wiki (too many ...
4
votes
2
answers
57
views
A native XML database management system needed
Wanted: a native XML DBMS (for a single user, single-transaction environment).
Requirements:
Unlimited number of attributes, elements, and namespaces
Efficient search (SQL-like and XQuery), full-...
9
votes
1
answer
519
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 ...
6
votes
3
answers
453
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 ...
1
vote
1
answer
229
views
Hadoop JSON Data to Data Warehouse
I'm interested in building a system that allows efficient loading of JSON stored in a Hadoop\EMR-based system to a relational data warehouse. I've already collected large amounts of JSON data in the ...
1
vote
2
answers
123
views
Is MS Access suitable for my use case?
A client has a small rehab clinic. They do everything using paperwork .
There about 5-6 doctors. So it is a multi-user app.
They need to keep some forms, medical records etc about each patient.
There ...
4
votes
2
answers
81
views
Managing massive sensor data within Ada code
I'm looking for a database system with these requirements:
Native support for Ada code.
Easy to store sensor data. I'm managing about ten sensors with a
sampling frequency or 1Hz, so I have about 1 ...
2
votes
1
answer
40
views
Business level loging solution
We are looking for a business level logging solution that has some of the features of both logging to a database and regular log files.
1) Regular log files are only readable by developers. Customers ...
2
votes
0
answers
68
views
Donation box management
Our organization has placed ~600 donation boxes across the country. 4 personnel are responsible for picking up changes and invoices from these boxes. This program has been running for ~4 years.
It ...
1
vote
2
answers
172
views
Software for (logical) data integrity checks in database
I'm looking for a data integrity checking tool that lets me specify rules with which it scans a database for logical inconsistencies.
Background:
We have a large application where the data integrity ...
2
votes
1
answer
26
views
Creating a cache for MySQL
I'm looking to create a cache for MySQL.
The issue is I have a relatively large table (hundreds of millions of rows) and there are a lot of fields associated with each row. The table gets probably ...
4
votes
2
answers
312
views
SQL tool that can use query result sets as temporary tables for further analysis and set operations?
For examples, lets say I need to do set operations and joins on below result sets from 3 different SQL queries:
I don't want to write a composite query with subqueries, or use temporary database ...
7
votes
2
answers
1k
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 ...
1
vote
0
answers
34
views
Storage Use Case "Logging + Images + Metadata"
I have the following use case for which I'm trying to find an optimal use of either filsystem, database (rdbms or a flavour of noSql solution). Any advice is welcome, as I want to see what is optimal.
...
4
votes
1
answer
137
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 ...
2
votes
3
answers
607
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
3
answers
4k
views
Fast-to-set-up HSQLDB database management GUI
I am looking for a GUI to quickly check an HSQL (Hyper SQL) database.
Requirements:
Fast to set up
Can be started from command line with filename as an argument
See tables
Run queries
Open source
6
votes
2
answers
477
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 ...
1
vote
0
answers
41
views
Tool to determine which normal form(s) a database's table violates
I am looking for a program that can determine in which normal form(s) a table is (e.g. 3NF).
If possible, I should be able to give an entire database schema as input, and not just one table of it. I ...
1
vote
1
answer
126
views
Project/Information Management Software
We are a cell tower services start up. I'm looking for web-based software that our workers on the field can login to and record cell site visits, crew inventories, detailed information about sites ...
5
votes
2
answers
722
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 ...
4
votes
0
answers
205
views
Free alternative to Oracle Maestro PHP Generator
I need to create a PHP page, that allows me to create/edit database entries.
I have a table, with several entries, I need users to go on a web page, and then, see and edit entries, and this need to ...