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).
622
questions
0
votes
1
answer
18
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....
- 171
1
vote
0
answers
22
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
...
0
votes
0
answers
15
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 ...
- 1
0
votes
1
answer
24
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 ...
0
votes
0
answers
5
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 ...
- 101
2
votes
2
answers
66
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 ...
- 21
0
votes
1
answer
37
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?
- 1
1
vote
2
answers
55
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 ...
- 111
0
votes
0
answers
49
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 ...
- 111
2
votes
0
answers
21
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 ...
- 121
2
votes
0
answers
23
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 ...
- 131
1
vote
2
answers
40
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)
...
- 850
0
votes
1
answer
21
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 ...
- 103
0
votes
0
answers
13
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 ...
- 1
1
vote
1
answer
53
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 ...
- 111
0
votes
0
answers
2
views
Proxy or gateway between application and database server
We are going through implementing ISO 27001 processes we have a requirement of having a proxy server between the application and database server, can someone suggest an architecture and tools to use?
...
- 101
0
votes
0
answers
8
views
A generic editor for trees and graphs of text
I am missing a generic editor, similar to a plain text code editor (like Kate), but not for lines of text, but for trees and graphs of lines of text or variant data records.
I always wondered why this ...
anon
0
votes
0
answers
11
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 ...
- 101
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
------------...
- 111
0
votes
3
answers
48
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 ...
0
votes
1
answer
33
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 ...
- 103
0
votes
0
answers
9
views
A database migration/refactoring tool for RDF triple stores?
Is there a refactoring tool that can track changes in database migrations, similar to Flyway or Liquibase, but for RDF triple stores?
Triple stores are similar to graph databases. They are used in ...
- 2,754
1
vote
1
answer
69
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 ...
- 15
0
votes
0
answers
10
views
App related to recipes, shopping list, menu, and diary
I am looking for an app which can import recipes from Google Keep (for instance, recipes may be defined in Google Keep using the Cooking label).
The app, lists the recipes, on the left, and they may ...
0
votes
0
answers
8
views
Hey, I am trying to create a database of phone where volunteers can enter their detail but I want that anyone should not change someone else data
I tried Google docs but if I enters my phone number and other info I want others to be able to add their own number and other info. But if I share link either they can only view, comment or edit.
I ...
- 1
1
vote
0
answers
19
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 (...
- 111
0
votes
1
answer
21
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 ...
- 1
1
vote
0
answers
28
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 ...
- 11
0
votes
0
answers
10
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?
0
votes
0
answers
9
views
Data Lineage tools for AWS data engineering?
My project uses AWS resources for data engineering. We use tools such as s3 for source, glue for transform and RDS as warehouse and several other. What are some of the best recommended and mostly used ...
1
vote
2
answers
36
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 ...
- 181
1
vote
1
answer
39
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 ...
- 11
0
votes
0
answers
16
views
High load traffic monitoring system tech advice
soon i will start developing personal project, it will be an internet traffic distribution and monitoring system, in this app i will have to keep track of each link visit and meta data that comes with ...
4
votes
2
answers
2k
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) ...
- 129
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
&...
- 111
2
votes
1
answer
31
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 ...
- 583
3
votes
1
answer
35
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 ...
- 341
1
vote
0
answers
27
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 ...
- 11
1
vote
1
answer
33
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?
- 111
1
vote
0
answers
35
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 ...
1
vote
3
answers
95
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 ...
- 19
1
vote
1
answer
33
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.
...
- 113
1
vote
2
answers
34
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 ...
- 13
2
votes
3
answers
66
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 & ...
- 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 ...
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 ...
- 111
1
vote
1
answer
115
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 ...
- 10.2k
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, ...
- 171
1
vote
0
answers
10
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.
...
- 11
0
votes
1
answer
16
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 ...
