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
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 ...
user avatar
  • 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 ...
user avatar
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 ...
user avatar
  • 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 ...
user avatar
  • 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 ...
user avatar
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 ...
user avatar
  • 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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
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, ...
user avatar
  • 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 ...
user avatar
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 ...
user avatar
  • 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 ...
user avatar
  • 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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
  • 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 ...
user avatar
  • 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 ...
user avatar
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?
user avatar
  • 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 ...
user avatar
  • 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 ...
user avatar
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, ...
user avatar
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.
user avatar
  • 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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
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(...
user avatar
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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
  • 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 ...
user avatar
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 ...
user avatar
  • 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, ...
user avatar
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 ...
user avatar
  • 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 ...
user avatar
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 ...
user avatar
  • 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 ...
user avatar
  • 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 ...
user avatar
  • 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: ...
user avatar
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 ...
user avatar
  • 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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
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.
user avatar
  • 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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
  • 121

1
2 3 4 5
12