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).
586
questions
0
votes
0
answers
10
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 ...
- 101
0
votes
0
answers
13
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
25
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
4
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 ...
0
votes
0
answers
17
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 ...
- 1
1
vote
0
answers
9
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
16
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
11
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
9
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,136
0
votes
1
answer
17
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 ...
- 101
1
vote
2
answers
22
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
22
views
Looking for an API for books
I am making a small library management system as a hobby and need something capable of looking up the title, genre(s), author, and description for a book from the ISBN number. I have already looked at ...
- 1
0
votes
0
answers
12
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
0
votes
0
answers
11
views
macOS Client to edit mySQL database on own server
I'm looking for a desktop app for mac that can be used to access a MySQL database on our own (web) server.
I want to display the database like a table (excel like), so anybody without any big MySQL ...
- 101
0
votes
0
answers
9
views
A temporal database that works differently from SQL Server
As I understand it, SQL Server temporal tables maintain a history of every composite value that a row has ever had. I'm looking for something that works a bit differently. I'd like all rows to be ...
- 131
0
votes
0
answers
16
views
Best web scraper to download html
I want to download some html from a website, add it to a database and display it on my own website.
Which webscraper and database would you use?
- 1
0
votes
0
answers
8
views
iPad / iOS Mysql database modelling tool
I'm looking for a tool for my ipad that will let me create MySQL database models.
Ideally it would also connect and sync to the database - or at the very least output SQL.
I use Navicat on my mac, but ...
- 1
1
vote
1
answer
43
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 ...
- 11
1
vote
0
answers
35
views
Software for tracking how much time cows spend with each other, and who they interact with
I am looking for a software recognition camera software for mountain cows, that can see at night as well. This software would track each cow, looking at how much time each cow spends with another cow, ...
0
votes
0
answers
11
views
Embedded ordered key-value store that is asynchronous
I am looking for embedded database, preferably an okvs that has an asynchronous interface, possibly based on io_uring.
- 111
2
votes
1
answer
63
views
Searching in .csv files on Android smartphone
I am looking for an app that allows easy search within .csv files.
Minimal features
can somehow read .csv files
allows to search in them (searching for exact match of string in any column) is ...
- 1,000
0
votes
0
answers
11
views
What is the ideal database to use for an application that will hold unique user data of an expandable list of dictionaries?
I created a fitness tracker web app, currently I am using mongodb as the database. In my app each day will be a new dictionary of various keys that I will then push to a list in the User Schema. I ...
0
votes
2
answers
44
views
Open source SQL database scalable on commodity hardware?
Is there an open source SQL database specifically designed or optimized for scaling on clusters built from commodity hardware? In other words, something that does for data what Beowulf clusters did ...
- 101
0
votes
0
answers
44
views
First Responder Kit Power BI Dashboard alternative
I noticed that the First Responder Kit Power BI Dashboard is Discontinued.
Is there any FREE alternative for SQL Server monitoring.
For now I'm working with:
IDERA SQL Check
Database Health Monitor
...
1
vote
0
answers
15
views
Flat file document database with recursion
I am looking for a database similar to Sqlite in terms of usability, but that stores one single document instead. That is, basic data like integers, floats, bytes, and also lists and dictionaries(...
- 111
0
votes
0
answers
18
views
SQL Server Profiler for DB2
We are working on a DB2 database and we would like to run a trace while queries are executed.
Usually in SQL Server we use SQL Server Profiler.
What is the same tool but for DB2?
(Propose more than ...
0
votes
0
answers
5
views
Survey application that hosts answers in cloud or my database?
I am helping a company that surveys people hosting their answers (around 22000 so far) on a range in Excels which I gathered to create a normalized dataframe with a target column in order to do some ...
0
votes
0
answers
17
views
Simple Knowledge Base (database with web frontend) with API
Are there simple knowledge base (or just database with simple web-frontend) with HTTP API, especially API for searching items.
Idea is to
fill that base with some data with that simple interface (by ...
- 101
1
vote
1
answer
102
views
Which database is good for automotive GPS tracker?
we are developing a recording system for automotive gps trackers production of our company.
we log their data nearly 1 year and each gps node sends data to record each 5 seconds. each data contain ...
- 11
1
vote
0
answers
38
views
Python package that compares an SQLAlchemy ORM to a pre-existing database schema?
Is there a Python package that will compare a live database schema to one defined in an SQLAlchemy ORM?
I have a decent size MS SQL Server instance (6 databases, ~200 total tables) that I need to make ...
- 111
1
vote
2
answers
62
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, ...
- 11
1
vote
0
answers
142
views
Recommendations for Stand-Alone NoSQL Database C++ Library
I am developing a Linux-only C++ open-source tool for (civilian) aircraft surveillance data inspection - think Radar data display and analysis (link).
Currently the app works with SQLite3, but I am ...
- 11
0
votes
0
answers
10
views
Visualization of data migration strategy
A legacy system is already running for years and a new version is being build from ground up. At the MVP milestone, customers will start to be migrated from the legacy system to the new system. For ...
- 101
0
votes
0
answers
19
views
File manager + Database
I'm looking for a convenient way to search and filter through a large number of files with customizable properties, so like a combination of a file manager and database software. In Windows I can sort ...
- 1
0
votes
0
answers
33
views
Amazon product advertising API alternative
Because my website is not online yet i could not use amazon products API in it, so I'm looking for an alternative that would let me do that.
so can you recommend any good free alternative to Amazon ...
- 101
0
votes
0
answers
14
views
What's the most efficient way to automate usage reports?
What is a good program for a small department to use in order to automate usage reports for their customers? We want to provide customers the ability to automate the pulling of their reports.
We have ...
- 1
0
votes
1
answer
29
views
Large (20m) data viewer with filter for int, float and date
I have 20m rows x 10 columns data looks like:
Col1 Col2 Col3 Col4 ... Col10
Row1 [str] [int] [float] ...
Row2 ...
...
Row20,000,000 ...
I am looking for a data viewer which supports:
...
- 198
0
votes
0
answers
22
views
Good java based database import tool
So as part of our system workflow I need to build a module that could import data to databases.
So rather than implement this module from scratch, I'm looking for an opensource tool that might already ...
- 1
0
votes
0
answers
5
views
Professional software for archiving hand written journals (with OCR)
I'm looking for software that will allow me to catalogue & search hand-written scanned journals.
My alternative is to pay someone to digitize these manually, but it's a lot, so a software suite ...
- 101
0
votes
0
answers
12
views
What DataBase is a better match?
I want to learn a Database and I'm looking for a database that has the best match with the programming languages that I use , That are C/C++ and Python .
Personally I stuck between mySQL and ...
- 1
0
votes
0
answers
20
views
I am looking for a free ERP for restaurant orders
They used to use OpenBravo in my company, but now this ERP is paid. Do you know another free one? I can't create one by myself, because I'm still in the first year of programming (I'm doing a first ...
0
votes
1
answer
129
views
Stand-alone Composer package for CRUD with PHP 8
For years, I've been making do with the outdated and ill-supported php-activerecord to do very simple insert and update operations for a tiny script that is for my own use and doesn't need to be a ...
- 113
1
vote
2
answers
28
views
How to use MySQL cloud services (gratis)?
I am new to web development. My team is planning to create a dynamic website as a project. I want to have a relational database (MySQL) but all tutorials seem to use MySQL and PHP locally. We want to ...
- 13
0
votes
2
answers
22
views
Do tools for generating documentation of PostgreSQL data warehouses/databases exist?
Something like Sphinx but for SQL, so we could document table structures and relationships in a series of web pages.
- 121
1
vote
0
answers
13
views
What database, cache or storage solution to use for large (~80GB) files?
Context
I have a bunch of image-like files that I need to store, and then retrieve and keep in memory as various calculations (only read operations) are performed on them. Imagine a library where you ...
- 111
0
votes
0
answers
22
views
which cloud db solution should I choose for fulltext search?
For my UWP and android apps, I started my project using firestore DB to store some user addresses and some business data, approximately 1M users data. Unfortunately, I missed to know in advance, that ...
- 101
2
votes
0
answers
13
views
Web application to manage data (podio alternative)
What I need is a recommendation, for an out of the box database with a UI on top.
Necessary features:
A database change log: every time an item changes, I need to be able to see what has changed.
A ...
- 121