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

Filter by
Sorted by
Tagged with
1 vote
2 answers
22 views

Program for research of relationships in diaries, reports, letters, etc

After my great aunt died, I inherited hundreds of letters, diaries and reports from my great grandparents and would like to evaluate them. To do this, I am looking for a (open source) program that ...
pappou's user avatar
  • 11
1 vote
0 answers
33 views

What solution can I use for edit SQL tables but with some patching of tables already done? like the SELECT JOIN

Hello I'm doing a side project based on mysql for the data part and php for the backend part of visualizing data, javascript and various libs for data representation and so on on the frontend. The ...
user3450548's user avatar
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
0 votes
0 answers
19 views

Reference management style software but for generic items

For some time I've tried to find some software that can be used as Zotero or BibDesk but for generic items,i.e. electronic units, or books, or test reports. Zotero would be perfect but the info tab is ...
I. I. Dobón's user avatar
0 votes
1 answer
10 views

Data analysis migration (user experience)

I have a challenge with databases, since we are currently working with Excel macros to carry out processes Users interact friendly with the database, changing rows, adding data, etc. We want to ...
user87162's user avatar
0 votes
0 answers
12 views

Software for Searchable Experiment Archive?

I'm looking into software recommendations for a company that has years and years worth of experiments, and it would be really useful to have all that in one archive which could be searched via a query....
Erin's user avatar
  • 1
0 votes
0 answers
40 views

Input data in database (e.g. via browser)

my company is very restrictive regarding new software and even programming languages. Basically I am limited to everything which is preinstalled on my PC, which is the Microsoft Office/365 Suite (thus ...
ju.'s user avatar
  • 111
0 votes
1 answer
100 views

Lower cost/small business alternatives to Claris/FileMaker Pro cloud product?

I have a small brick and mortar business client who needs better side-channel invoicing. They're currently using Excel, but this doesn't give them statements, and some other databased-related features....
xtian's user avatar
  • 171
1 vote
0 answers
28 views

Open source database library with C API

I am looking for the open source library similiar to SQLite. The requirements are: C API C/C++ backend server-less configration properties (e.g. no dynamic allocations, crash tolerance) open source ...
Marcin Puchlik's user avatar
0 votes
0 answers
21 views

Recommendation for a tax calculation and filing system?

Right now my company uses Avalara to perform the functions of tax calculation, tax filing, tax exempt certificate management, and address validation. However, we want to end our contract with Avalara ...
barpgoy's user avatar
0 votes
1 answer
34 views

Automatic inventory based system for construction company

I work for a cement contracting company. I need a program that already does this or a push in the right direction for a software that keeps track of all inventories that is stored at the main ...
Kane Hamilton's user avatar
0 votes
0 answers
6 views

Looking into MaxScale

I am looking to ease the maintenance of working with our databases and having a single point of management that can accomplish the following Load balances reads to replicas Sends writes only to the ...
Joséph Flames's user avatar
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
0 votes
1 answer
73 views

What's the best graph database to start with? [closed]

I'm planning on switching from RDBMS to Graph database, can anyone recommend what's the best tool for beginners?
sha's user avatar
  • 1
1 vote
2 answers
64 views

Affordable Cloud Database

I need a cloud database for a website that I am launching. This website is only a hobby at the time of writing but I want to be able to scale if I generate revenue and a lot of traffic. The website ...
Divan's user avatar
  • 111
0 votes
0 answers
228 views

Java based key-value store (embedded database) with incremental persistence and transactions

Any recommendations for a Java based key-value store embedded database? Requirements are: It should support transactions It should support saving and loading from incremental changes. What I mean by ...
morpheus's user avatar
  • 111
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
1 vote
2 answers
42 views

What databases have both iOS and Android clients and can work offline?

Is there any database that: has iOS and Android clients to do basic operations (CRUD) open fast synchronizes to one central source doesn't require internet to work (the operations can be sent later) ...
Ooker's user avatar
  • 850
0 votes
1 answer
23 views

Are there some private library apps that can connect to a custom DB?

I have a couple thousand books and I have been organising them since COVID broke out. I have been using BookBuddy+, but sadly its API is borderline non-existent and now that I am planning to sell some ...
eslukas's user avatar
  • 103
0 votes
0 answers
14 views

Tool for collecting, annotating, and analyzing social media-/text-data

I am looking for a tool that allows me to collect, annotate, and analyze social media data. I am interested in collecting data from a variety of sources, including Facebook, Twitter, and Reddit. I ...
Andy's user avatar
  • 1
1 vote
1 answer
114 views

I need key-value or SQL database with multi-master replication and very low requirements

I'm creating self-hosted DNS-service, that can be run by any user on it's servers. The purpose is to parent-control of the available websites and block adverstments and phishing sites by publicly ...
MihanEntalpo's user avatar
0 votes
0 answers
17 views

Tools for data collection

Lets say you want to collect several datas from branch office. The data will be analyzed to evaluate the monthly performance. What is the best way to collect the datas? Currently I'm using excel ...
One Attack's user avatar
1 vote
0 answers
7 views

Prediction Model for Dataset

Consider the following example dataset with 1-minute timestamps and 5 numerical columns: Example dataset: Timestamp Column 1 Column 2 Column 3 Column 4 Column 5 Result ------------...
Bosser445's user avatar
  • 111
0 votes
3 answers
71 views

Android app that's able to take photos, get the geographic information such as GPS coordinates, and export to a spreadsheet large-scale

Long story short, I am working on a project where we have to take photos of thousands of machines and have GPS proof of that saved in a database. The best I've found yet is the "Smart GPS ...
Aaron Lopes's user avatar
0 votes
1 answer
38 views

Desktop database tool with custom form and rich data display

Basically a generic CRUD application for desktop. I found Database Tour which displays the data pretty well, supporting url, image, boolean checkbox, etc. However it doesn't have a custom form GUI for ...
skygate's user avatar
  • 113
1 vote
1 answer
136 views

Open source Google Sheets alternative for storing data for people who don't know how to work with databases

My coworkers use Google Sheets for saving orders data with different parameters like order number, date of creation, status, expected date to finish production for this order and so on. There are some ...
NaleVex's user avatar
  • 15
1 vote
0 answers
26 views

Alternative to Microsoft Flow

Been trying Microsoft Power Automate (Flow) for some time now and i'm tired of having to do workarounds for the simplest task due to poor support and connectors. I'm automating database related tasks (...
jared's user avatar
  • 111
0 votes
1 answer
25 views

Looking for database to store multiple mapping dictionary

I have multiple excel sheet, which used to store statistical tables (around 10 stables, 2000x4 each) and use these tables to compute the formula. I am now using Python, thinking should I store these ...
tung's user avatar
  • 1
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
0 votes
0 answers
11 views

How to shrink a huge database on a webserver, so it can be developed on and run locally

The size of the database on the webserver is on the order of 100s of GB, I can't run that locally on my PC. How do I shrink the database so I can test new features for the website?
thedankvank's user avatar
1 vote
2 answers
40 views

Grocery app with price-per-shop and aisle-per-shop?

Back in the old PalmOS days, I had a grocery app which had these features: You would enter any items yourself (obviously - that was in the pre-Smartphone days; no internet on the device) You would ...
AnoE's user avatar
  • 181
1 vote
1 answer
42 views

Libraries to digitally sign measurement data via smart cards

My employer asked me to write software that allows colleagues to digitally sign measurement data (Windows 10). I received a developer kit consisting of a card reader, smart cards and software to ...
Leo's user avatar
  • 11
5 votes
3 answers
4k views

Command line SQL formatter or beautifier

I am looking for a command line SQL formatter = SQL prettifier = SQL beautifier (offline, not an online formatter) for Mac. The goal is to run it on the command line and also inside the editor (Emacs) ...
Timur Shtatland's user avatar
0 votes
2 answers
31 views

Database for having very long but simple tables

I am in need for a database that can store very long tables. E.g. MYTAB ----- name STRING date DATETIME mark INTEGER value DOUBLE "A.112.akizo", "2023-01-01 01:00", 0, 1234.54 &...
chris01's user avatar
  • 111
2 votes
1 answer
33 views

Search engine that creates tables of information about a subject from unstructured data

I am looking for a webapp that would gather data from the web in a very similar way to a search engine, but instead of presenting the results as a list of titles and abstracts, it would dump the ...
Lockszmith's user avatar
3 votes
1 answer
36 views

Software with a database to lookup hashes of files

Sometimes it happens that an open source project adds files with a wrong license. For example the C code of a game is GPL-2, but by accident a sound file from a proprietary source was copied to the ...
Jonas Stein's user avatar
1 vote
0 answers
34 views

No code or low code SaaS database for a collector community where anyone can view, edit, and search for items

Before I go any further, here are some things to note: I am a normal individual with a normal low-paying job, with a passion for collecting. I am not some big business owner CEO with thousands of ...
Deko's user avatar
  • 11
1 vote
1 answer
37 views

Software to recognize TV show video?

I have a lot of recorded videos. I know the show name, but don't have the episode name. Is there software to recognize episode name by video?
Bill Martin's user avatar
1 vote
0 answers
46 views

Using Java, what other libraries are avalible for easily converting CSV files to DBF (dBase/xBase)?

I am currently writing an android app that interfaces with database files and was considering a way to export data neatly without errors. Currently every library I can find has one issue or another ...
cellswithincells's user avatar
3 votes
3 answers
357 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
1 vote
1 answer
38 views

MySQL interface with copy/paste functionality and conditional formatting

I am looking for a MySQL UI with some spreadsheet-like features. We need: Copy & paste functionality Conditional formatting I have tested a lot of tools and have not found exactly what we need. ...
Alan Reed's user avatar
  • 113
1 vote
2 answers
39 views

Staff rota scheduling software

My partner runs a pub and spends ages every week designing a staff rota for her bar and kitchen by hand on a sheet of paper. I'd like to drag her into this century and get her using some software that ...
David's user avatar
  • 13
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
0 votes
1 answer
21 views

What's a good database stack for hosting online books? [closed]

I want to be able to request specific pages at a time, and be able to quickly go to previous and next pages of a single book. Lots of read requests. Not nearly as many writes. Should I go for a NoSQL ...
user82093's user avatar
1 vote
0 answers
13 views

Which database is best suited for 100 Million time series data?

I am looking for a database that gives me fast query and insert operations. Following are the possible expectations from the database. A lightweight database. Time series query database that can ...
Prog_G's user avatar
  • 111
1 vote
1 answer
416 views

Generating Python classes for SQLite database

I have a SQLite 3 database and I need to write Python code that deals with it, basically the typical CRUD operations as an object oriented wrapper around the database. I find myself writing stupid SQL ...
Thomas Weller's user avatar
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
1 vote
0 answers
11 views

Looking for ticket creation/logging software

I am looking for a free software to print tickets and log entries into a text/Excel file. It needs to do these few things: Have an area where user can input name, and have a local account of sorts. ...
Volvo240's user avatar
1 vote
1 answer
21 views

Tool to manage multiple characters

I absolutely love games where you can create custom characters, particularly ones where you create multiple characters that exist together rather then just customising the protagonist (e.g. the Sims ...
CharacterMan's user avatar

1
2 3 4 5
13