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).
607
questions
0
votes
1
answer
27
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 ...
- 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 ...
2
votes
1
answer
158
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) ...
0
votes
2
answers
29
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
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 ...
- 573
3
votes
1
answer
26
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
26
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
27
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
28
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
37
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
28
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
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 ...
- 13
2
votes
3
answers
59
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
19
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
11
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
0
votes
0
answers
18
views
How accomplish data manipulation like in screenshot
I am trying to figure out how to manipulate data as on screenshot.
Is this possible in Google Sheet or should I use other tool (some database?)
I have some Car parts (Part ID) that fit the general car ...
- 1
1
vote
1
answer
30
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 ...
- 9,805
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
0
answers
21
views
Desktop program to tag and create a database of photos that can be exported in groups (or automatically update)
So I'm trying to create folders full of certain types of images. So for instance, I might have a hundred photos and then I would tag a bunch of these photos with attributes like "subject : ...
0
votes
1
answer
10
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 ...
1
vote
1
answer
22
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 ...
- 11
0
votes
0
answers
22
views
What is a good alternative for ORMlite?
I am looking for an alternative ORM wrapper library to ORMlite as I found that the current version 6.1 has the follwing vulnrabilities:
CVE-2022-23305
CVE-2022-23302
CVE-2022-23221
CVE-2021-42392
CVE-...
- 101
1
vote
0
answers
18
views
Best Azure Time Series Insights alternative
For a new project I am looking for a way to store data in Azure. Since the data is data coming from IoT devices, my thoughts jumped to a Time Series Database and looking at the documentation that ...
- 11
0
votes
0
answers
11
views
Storing and analyzing viewer stats on videos
In the context of an online video player, I need to track viewer behavior. Say I start a timer when the viewer presses play: then I can check the timestamp of the video against the timer - this will ...
- 165
1
vote
0
answers
18
views
Time series database with offline data caching
I am looking to develop a system that monitors a sensor using an Android app and uploads that to a remote database for storage and visualisation.
Is there a commonly used architecture which can meet ...
- 121
1
vote
1
answer
39
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 ...
- 111
0
votes
0
answers
25
views
blockchain database in java
I have some data to store in database. Those data should be immutable. I thought that it will be nice to make it immutable by using blockchain. Implementing something like this from scratch might take ...
- 1
2
votes
0
answers
27
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 ...
0
votes
0
answers
13
views
Is there a purchase-receipt tracking, belonging, "owned object" database that's better than a spreadsheet?
Partially for insurance purposes, partially for quantified-self nerdery, and partially for my own sanity, I want a database of "things I own."
There's a ton of information buried in my e-...
- 166
0
votes
0
answers
7
views
Tool to switch database dumps when changing branches?
In a previous job, we had an in-house tool that allowed us to, after switching branch in revision control, restore (via e.g. pg_restore) a database dump that was a best-effort attempt at being ...
- 101
0
votes
0
answers
9
views
Question - DB from Email Attachments
I've got quite a random question here - but trying to solve a business problem.
We have a legacy CRM which allows us to export data at regular intervals, but the data is delivered via email and ...
- 1
1
vote
0
answers
12
views
Software to assist with validating files against a schema and automatically generate files from database
A company I am working for currently uses BizTalk to gather data from their database and put it into the desired format (EDI X12 834), which is an extremely regulated format that must be created ...
0
votes
1
answer
38
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 ...
- 1
1
vote
0
answers
14
views
Looking for site people can text pictures to upload for beautification
first time here.
I oversee the grounds of a 240 acre public institution. It has beautiful grounds, but there are always maintenance needs.
I'd like to publicize a phone # where people can take a ...
- 11
0
votes
0
answers
12
views
Tool (database, filesystem, etc.) or strategy for providing fast consistent random access to tens of millions of small data chunks
I'm working on code for a personal project and I have the need to store potentially tens of millions of small, similarly but not equally sized pieces of data, between 128KB and 1MB each (average ...
- 111
0
votes
0
answers
18
views
What is a good database tool for offline access?
I'm trying to find the right database service to use. I need multiple computers (1-5) to be able to access/write/read to the database simultaneously, locally (without internet access, via connecting ...
1
vote
0
answers
27
views
Tool to draw the whole information flow architecture from source systems through a data warehouse up to data mart for BI and analytical needs
I'm working for IT company that maintains multiple complex separate systems with own transactional databases.
We're working on BI platform that uses data from all these systems and I'm looking for ...
- 11
0
votes
0
answers
9
views
Android database app with local storage for 10m files
I'm looking for an Android app that can store a database of ~10 million records on-device (storage space permitting) and efficiently search it. Bonus points if there's a nice GUI for searching on ...
- 141
0
votes
0
answers
5
views
Enterprise data modeling tools for Postgres
Is there anyone who is using an Enterprise data modeling tool (i.e. ERWIN, ER Studio) with Postgres?
We have used ER Studio for Oracle for over 15 years, our process is to use the tool to take a ...
1
vote
0
answers
22
views
Raw data spreadsheet
I use little tables that contain mainly text on a daily basis. I currently use LibreOffice Calc to view and edit them, with the Autofilter feature for sorting and filtering. However, spreadsheets are ...
- 11
1
vote
0
answers
13
views
Which free and opensource NoSQL database provides feature for creating groups/buckets of documents?
I am learning CouchDB. As I understand it, documents in the database cannot be grouped into categories, such as, for example, all receipt documents can be put into a receipt bucket, invoices can be ...
- 111
0
votes
0
answers
17
views
Could you please recommend software/library/module that can do abstraction of connecting and working with databases maybe with CRUD Interface?
I have spent several days on web, but i am unable to find answer to my question: Currently we are looking for software in form of (preferably) NodeJS module/library. The library should abstract tasks ...
0
votes
0
answers
63
views
PostgreSQL client with boost::asio integration
My team is in the process of rewriting a legacy application written in C/libevent to the modern tech stack (we decided to use C++20 and boost::asio). The old implementation suffers from poor ...
0
votes
0
answers
16
views
Adminer Plugins for various MySQL and MSSQL -related dba administration tasks
I am a big fan of the free Adminer database query and admnistration tool, - a webapp that consists of a single (minified+scrambled) PHP page.
The plain variant of Adminer is/was designed for mySQL, ...
- 2,456
1
vote
1
answer
50
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 ...
- 111
1
vote
2
answers
27
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 ...
- 411
1
vote
0
answers
15
views
Generate editable data grids for existing database (Lightswitch alternative)
We have an existing database that we need an editing UI for. For 70% of the tables we just need a simple editable data grid. The other 30% have one-to-many relationships that require a more ...
- 111
0
votes
0
answers
13
views
Is there a T-SQL refactoring tool out there that can remove subquery statements into temporary tables?
I have recently been given a lot of T-SQL scripts that are alien to me in terms of what they do and tasked with reworking them to remove all subqueries and write them to temporary tables instead.
I ...
1
vote
0
answers
7
views
Need help on backend user account management and data persistence
So I'll keep it short. I have a website where my users can come and write and the strings of text are saved using their localstorage, meaning whatever text they write in that textarea stays saved on ...
- 11