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).
609
questions
3
votes
1
answer
98
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 ...
CommunityBot
- 1
0
votes
0
answers
6
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
1
answer
61
views
Big data solution to count unique values in real time
So, I have a table in mysql that stores user interests, initially it was just data to analyze when needed. The users_interests table is a table that stores the user_id, the section_id, the location_id,...
CommunityBot
- 1
1
vote
0
answers
15
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
1
vote
2
answers
102
views
I'm developing an android food ordering app, what software do I use to send the order to another device?
I'm making a project and I need to find a way to submit a food order to another device, like McDonald's does. Like when a customer chooses their order and they submit it to the kitchen for the food to ...
CommunityBot
- 1
3
votes
4
answers
302
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 ...
CommunityBot
- 1
1
vote
2
answers
29
views
Tool to manage and display n:m relations
I'm looking for something that can store, manage and display a fairly simple set of data and their relations. But since these are n:m relations, obvious solutions like Excel don't work well.
What I ...
CommunityBot
- 1
1
vote
1
answer
42
views
Is there a GENERIC (windows) program to do CRUD for a database table
I am looking for a generic input frontend to perform simple CRUD in a database, either MySQL or SQLite. Ideally I should be able to read the table specification (describe XYZ) and the program would ...
CommunityBot
- 1
1
vote
1
answer
2k
views
Recommendation for personal database (Bento replacement) for iOS and OS X
Looking for a personal database recommendation for iOS and OS X – basically a replacement for Bento. It needs to be able to have cloud sync, so I can do work on multiple devices.
Two options seem to ...
CommunityBot
- 1
1
vote
2
answers
171
views
Best database to store time-series data in memory on Linux? (Embedded application)
I currently working on a Linux embedded application where I do some logging every second for numeric data (I really just need to plot data on a graph for the last 24 hours of operations).
Since SD ...
CommunityBot
- 1
2
votes
2
answers
78
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, ...
CommunityBot
- 1
0
votes
1
answer
14
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
vote
2
answers
30
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 ...
- 678
1
vote
2
answers
59
views
Is there a database software that can accomplish this?
A professor at my workplace wants to setup a server for a database.
Users should be able to access the server with a GUI and create entries, add files to entries and edit metadata that is associated ...
CommunityBot
- 1
1
vote
0
answers
20
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
1
answer
32
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 asign ...
CommunityBot
- 1
1
vote
1
answer
132
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 ...
CommunityBot
- 1
0
votes
0
answers
9
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
5
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 ...
0
votes
1
answer
42
views
Which modern IDE to choose when working with Oracle database on Windows?
Good afternoon!
I am working with Oracle Database (mostly writing queries, stored procedures and creating tables). The problem is that I can not find a modern IDE to work with Oracle such as Visual ...
CommunityBot
- 1
3
votes
3
answers
80
views
Which simple data storage option for large amount of non-relational data
I am looking for a good solution to store and retrieve a large set (let's say a few hundred million or even up to a billion) of data items consisting mostly of strings (but a few numeric fields as ...
- 902
0
votes
2
answers
54
views
Client for performing ElasticSearch requests
I make a lot of use of an ElasticSearch server, and up until now have been using Sense. However, this has recently disappeared from the Chrome Store, and our IT department's virus scanner has disabled ...
CommunityBot
- 1
1
vote
1
answer
83
views
Evernote with custom properties. Notion with full offline support
I need a desktop RDBMS to conveniently manage a bundle of rich text notes -- CRUD, adding tags, search inside notes, backups, etc. In a way, I need a light, abridged, desktop only version of Evernote ...
CommunityBot
- 1
1
vote
2
answers
373
views
Looking for a Game Database Management Tool
I've been using CastleDB to organize my database and it has everything I needed to quickly define the static data for my entities BUT it has a few bugs that make it too frustrating to work with (...
- 1
0
votes
1
answer
50
views
What combination of toolsets is cost effective for hosting an intranet website?
Conditions:
I need to be able to support a database that is small and multi-user access
I need server-side and client-side programming/scripting
I need it to be license free - or low cost, yet ...
CommunityBot
- 1
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 ...
CommunityBot
- 1
2
votes
2
answers
70
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 ...
CommunityBot
- 1
1
vote
1
answer
349
views
File-based database: Sqlite, MongoDb or else?
I am looking for a file-based database solution, where the original inputs are in csv format.
Key info:
One complete dataset is a static collection of files. However, I will need to have multiple ...
CommunityBot
- 1
7
votes
1
answer
208
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 ...
CommunityBot
- 1
0
votes
1
answer
71
views
Secure data transfer (for DB/ETL)
Does anyone know of any tool, ETL suite or BI suite that enables safe and secure data transfer from one location to another, over internet to an offsite database in the cloud? Or, what approaches ...
CommunityBot
- 1
2
votes
1
answer
54
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 ...
CommunityBot
- 1
0
votes
1
answer
45
views
Multiple application 'base' configuration definitions stored in.....Enterprise Arch/CMDB/etc?
I'm trying to find software to put ~10 different software pieces of information. The pieces of information include the following for the 'base' install:
intended tested operating system
other pre-...
CommunityBot
- 1
2
votes
3
answers
60
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 & ...
CommunityBot
- 1
1
vote
3
answers
47
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 ...
CommunityBot
- 1
2
votes
1
answer
30
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 ...
CommunityBot
- 1
2
votes
1
answer
659
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 ...
CommunityBot
- 1
0
votes
0
answers
13
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 ...
1
vote
1
answer
23
views
Database schema serialization and deserialization
I'm looking for a library (Python ideally) that can implement changes to a database schema based on schema definitions in YAML (or any other serialized format).
I would like to define the schema of a ...
CommunityBot
- 1
2
votes
1
answer
348
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) ...
- 107
1
vote
2
answers
50
views
Graph database / client for Python?
I need a graph database usable from Python. The goal is representing email communications like "X contacted Y on Jan 10th who on Jan 20th contacted Z", etc.
I loved to see Bulbs: https://github.com/...
- 111
1
vote
1
answer
89
views
Linux CLI tool for auto-formatting (pretty printing) large SQL files
I've got a large (3 GB) SQL file that came from a SQL dump. Reading it is impossible because it's formatted poorly. For example each table has a giant INSERT statement that is indecipherable.
Is ...
1
vote
1
answer
28
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?
CommunityBot
- 1
0
votes
2
answers
30
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
&...
- 2,516
1
vote
2
answers
97
views
Need a database for a single-user app to sync data across computers without storing on the internet
Need suggestions for a database. I'm tasked to write a C# desktop application for a small business. The business owner does not want his data to be stored on the internet. He has two desktop computers....
CommunityBot
- 1
0
votes
1
answer
232
views
What's the difference between Shared Preferences (Android) and NoSQL? Why would I choose NoSQL for simple XML storage?
I am storing simple data and my boss is keen on using a key-value pair database to do so. The developer before me chose SnappyDB, which is a NoSQL database similar to Mongo, Couch, and Redis.
...
CommunityBot
- 1
0
votes
1
answer
65
views
Interactive PDF to management of reports
I am looking for some solution for management of reports. Is it possible to create interactive PDF with functions like:
add images
add attachments like images, emails, files etc.
sending information ...
CommunityBot
- 1
1
vote
2
answers
27
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 ...
2
votes
1
answer
27
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
27
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 ...