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).

307 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
8 votes
0 answers
182 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 ...
Alex's user avatar
  • 181
7 votes
1 answer
240 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 ...
WeirdestQuestions's user avatar
5 votes
0 answers
82 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 ...
Pierre's user avatar
  • 121
5 votes
0 answers
94 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 ...
B-M's user avatar
  • 151
4 votes
0 answers
238 views

Software for auto parts management

My name is Adrian. We own a second hand car parts store. We buy cars, disassemble them, and sell them by the piece. At the current moment all the prices are, unfortunately, in my head, so we need to ...
zloteaadrian'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
0 answers
276 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 ...
Samuel Marks's user avatar
4 votes
0 answers
207 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 ...
Nico's user avatar
  • 141
3 votes
1 answer
93 views

Simple in-memory database with persistence in one file

I'm looking for an in-memory database, where I will keep a long list of records. Each record will have a variable number of non-unique (!) attributes (similar to how NoSQL tables are organized). I ...
yegor256's user avatar
  • 131
3 votes
2 answers
91 views

Customer data organisation tool

I'm looking for a tool, that stores our contact data from our customers/ clients. Current situation: Currently we store everything in an excel spreadsheet. With columns for: First Name, Last Name, ...
skarpeta's user avatar
3 votes
2 answers
78 views

Write a big comparison table

I want to write for myself a very big comparison table for myself. I want to write all the equivalent features (rows) for the programming languages I know (columns). For example, how to iterate over ...
Rafi's user avatar
  • 31
3 votes
0 answers
45 views

Best Key-Value database for intensive insertion

We are working on a project of type (intensive insertion) should able to handle millions of insertion per day. The Current situation we have two table one of them includes 2 billion record (Id & ...
Tarek's user avatar
  • 31
3 votes
1 answer
164 views

Mobile Friendly Data Entry App

I am trying to create a data entry "app" to collect daily readings across our site. Here are the three biggest constraints: Software - ideally, we would use some software within the Microsoft 365 ...
setty's user avatar
  • 131
3 votes
0 answers
46 views

Schema Mapping Tool

I have several flat file data sources (CSVs) that are extracted, transformed and loaded into relational tables. At some point in time, when I look at a table, I often have a hard time figuring out ...
Abhilash Kishore's user avatar
3 votes
0 answers
39 views

OCR Deep Learning Software

I have a question about a possible software solution for a problem. I work in a very busy psychiatric private practice that handles large amounts of paperwork. We would like to create a more efficient ...
NeoMoneyX's user avatar
3 votes
0 answers
135 views

Online Content Management Database for Media and Literature

As part of research project, I'm looking to manage media (images, video, sound) and literature (a screenshot with DOI or links to the source) I collect into an online database for myself and others to ...
Domenico's user avatar
3 votes
0 answers
59 views

Microsoft Access to MySQL Database Converter

I am working on creating a basic master-detail application using VB.NET and MySQL, because of this I've tried to look for a simple master-detail application using VB.NET in the internet and I found ...
Cary Bondoc'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
3 votes
0 answers
109 views

Relational Personal Media Explorer

I want a windows 8 compatible program that will help me track my media collection in a way that helps me keep track of files and will support relations. Currently, I am using Tabbles to tag files ...
Mitch's user avatar
  • 31
3 votes
0 answers
58 views

laboratory database software

I am working in a small (three person) physics laboratory and would like a robust and convenient way to log data. Writing a custom python script to iterate through the lines of a data file, converting ...
creillyucla's user avatar
3 votes
0 answers
62 views

Database schema and data management tools

I've been using Visual Paradigm on both mac and linux to simutaneously manage my database's schema and example/test data during development. I have found their interface to only get buggier over time ...
sam's user avatar
  • 131
3 votes
4 answers
312 views

Form builder with local data storage, Mac compatible

I have a series of records, each of which has the same fields. I’d like to build a form interface to start editing these records, as managing them in a text file is unwieldy. Simply having a few ...
duozmo's user avatar
  • 211
3 votes
0 answers
451 views

Async Oracle Driver for .NET

I am looking for an async capable (using the async/await features) .NET client that can connect to Oracle 10GR2 and higher databases. Free and open source is preferred, but other suggestions are ...
mason's user avatar
  • 161
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 ...
Pubename's user avatar
3 votes
3 answers
356 views

I want to create a fully portable database on external hard drive - where to begin?

I have a huge collection of files (movies, music, etc) on an external SSD. I wanted to build some kind of local website at the root of that SSD, which could let me create a custom playlist with ...
Chuck C's user avatar
  • 39
2 votes
2 answers
75 views

What software can I use to make an interconnected list of my music which is relatively easy to browse?

Context: I perform music in a cover band. It often takes a little time for us to decide on a set list of songs, or sometimes we deviate from the set list depending on the vibe. Sometimes, we just go ...
Boloar's user avatar
  • 21
2 votes
0 answers
27 views

forms builder or survey software or CRM or CMS or DMS allowing Editing of the responses

Custom fields A forms builder or survey software or CRM or CMS or DMS which allows Editing of the responses Each response can be edited only by the user who answered the survey questions Maintains a ...
Shanthi's user avatar
  • 121
2 votes
0 answers
33 views

Reverse-engineer PostgreSQL query into diagram

Is there a tool that can show a diagram of tables involved for a PostgreSQL query? Must support: WITH syntax Subqueries Joins Lateral joins Nice to have: Columns involved Recursive expand ...
pkExec's user avatar
  • 131
2 votes
1 answer
47 views

What is a Software to handle large amount of google form responses

I have a google response form that is connected to a Google sheet. However, due to the large volume of responses the spreadsheet is running too slow to open and operate within. I think the spreadsheet ...
RedAce's user avatar
  • 21
2 votes
3 answers
74 views

For PhD: Software for Cross-Matching & Organizing Files & Recordings + Metadata

For my PhD I am accumulating thousands pdf and word documents from with lecture notes, transcriptions, powerpoint slides, and handouts. I also have several thousand recordings of lectures & ...
Michel's user avatar
  • 21
2 votes
0 answers
29 views

How to setup a publicly accessible read-only database of emails?

I have been part of an email group for many years and have ~20 GB of emails on it. I want to setup a new / independent system where I can load all the emails I received as part of that group. However, ...
siliconpi's user avatar
  • 181
2 votes
0 answers
32 views

FOSS data stack to perform complex custom logic on billions of ordered rows

Is there a purely analytics-focused (i.e. a handful of technial users, no business users or clients) FOSS data stack that would enable me to ingest several hundred million up to a billion of rows per ...
McPeanutbutter's user avatar
2 votes
0 answers
16 views

Web application to manage data (podio alternative)

What I need is a recommendation, for an out of the box database with a UI on top. Necessary features: A database change log: every time an item changes, I need to be able to see what has changed. A ...
JohnDoe's user avatar
  • 121
2 votes
0 answers
165 views

Frontend for CRUD operations Postgres

I need a frontend for CRUD Operations on a Postgres database. It has to be understandable also for persons without database background. Also it would be nice if it is open source and free (and maybe ...
ThoPa's user avatar
  • 21
2 votes
1 answer
263 views

Easy to use database software to maintain music inventory

A friend of mine - a typical babyboomer - has a very extensive music inventory, especially a lot of compilation albums. He used to maintain a database software program called Reflex. Every time he ...
Jeremy Anderson's user avatar
2 votes
1 answer
33 views

Create reports/queries via a GUI that respect database relations (replace Oracle Discoverer)

I am looking for a tool to replace Oracle Discoverer. The main goal is to support non-technical users in their reporting. Despite other functionalities, the main ones are as follows: The must-have ...
user64579's user avatar
2 votes
0 answers
327 views

Index Analysis and Tuning tool for PostgreSQL, MySQL, and Oracle?

I have used SentryOne Plan Explorer to perform index tuning and index analysis with great success on SQL Server and Azure SQL Database. What are some of the better equivalent tools to consider for ...
Jaxidian's user avatar
  • 121
2 votes
0 answers
16 views

Software to detect column relationships in a table?

Consider the following scenario: There are two columns in a table, ACCT_STA_CD (Account Status Code) and ACCT_CLSD_DT (Account Closed Date). In ACCT_STA_CD, the value of 'A' means 'Active'. Since ...
njrob's user avatar
  • 21
2 votes
2 answers
65 views

Recommendations for software, library or framework to delta large CSV Files

I am currently investigating what is out there that would quickly and efficiently compare and produce a delta from CSV Files. What I am dealing with is data that is outputted from Sybase ASE. These ...
Ash's user avatar
  • 121
2 votes
0 answers
14 views

An embedded database server, which can be connected to over network

I require an embedded database server(RDBMS or Document) which I can start within the current application process, which can be connected to over network for .Net. Do you have any recommendations? ex....
user3614386's user avatar
2 votes
0 answers
25 views

Functional offline browsing solution

Problems: Site with with some useful data can go offline. It can be shot down by government, it can run out of money, it can go down by million other reasons. The result -- data is lost. Site can ...
Brian Merphy's user avatar
2 votes
1 answer
60 views

What application for storing data based on metadata, and retrieve it via metadata search?

In our institution we have a large database of observational data consisting in precipitation, temperature, elevation and a large number of other variables, coming from different projects and in ...
AF7's user avatar
  • 71
2 votes
0 answers
11 views

Database for R^n --> R^m function evaluation caching

I'm trying to choose the best database for caching a n inputs, m outputs function: It has to persist the result of the evaluation of some (costly) R^n ---> R^m function. So there's a fixed structure: ...
Lester Jack's user avatar
2 votes
1 answer
767 views

On-premise alternative for AWS QLDB

What is the best alternative for on-premise solution with the same features as Quantum Ledger Database - AWS QLDB? transparent, immutable, and cryptographically verifiable transaction log owned by a ...
Igor Ba's user avatar
  • 21
2 votes
0 answers
37 views

Syncronization between Ionic App DDBB and Server DDBB

I am developing an application with Ionic Framework and NodeJS and I have some doubts when choosing the databases to use. I explain the funcionality I want for my application to see if you can help ...
Jorge Morata Toribio's user avatar
2 votes
0 answers
25 views

Database for metric space search

I have a huge list of vectors (extracted from images, text, audio, whatever) and I want to do metric search. I want to input a query vector and retrieve the closest ones to it according to the ...
user4052054's user avatar
2 votes
0 answers
48 views

Best/most efficient database for saving per basis settings

I have a Discord Bot that's on a many a servers, I'm revamping most all of it and came to a personal crossroads. While developing I used the schema that I saw Red Discord Bot use which under the hood ...
Jab's user avatar
  • 121
2 votes
0 answers
35 views

file synchronisation with central database

I'm looking for a file synchroiniasion on W10 like Synctoy, NextCloud or FreeFileSync. However, I want a central database that stores the data for deletions and renames. FreeFileSync, NextCloud, and ...
musbach's user avatar
  • 135
2 votes
0 answers
16 views

Any library in Java or Python for storing lots of small objects in AWS S3 "intelligently"?

I need to store a lot objects in S3, and I need to be able to address each object fairly quickly (maximum of 2 GETs to find one object) and I don't want to be wasteful when comes to the number of PUT ...
Alex R's user avatar
  • 221
2 votes
0 answers
32 views

Embeddable, interactive reporting tool

I am looking for a reporting tool, however, I’m a real beginner. I hope that someone can give me some ideas. Requirements: Can connect to databases (Postgres) Produce simple charts and tables Online ...
JustQuest's user avatar

1
2 3 4 5
7