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

1
2 3 4 5
13