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).
566
questions
0
votes
0answers
14 views
Web CSM for database and search
I'm working with a small database built from spreadsheets, so I have several CSV files that may be related through column keys.
I want to upload this work to a webpage and allow people to search ...
0
votes
0answers
22 views
Which OR mapper would you recommend for a new application (C# .net) with an existing database
We want to write a new application in C# that uses our existing database (SqlServer).
There are many stored procedures and functions in the database. The database has several schemes.
Which OR mapper ...
0
votes
0answers
30 views
Create survey questions from a database query
The following diagram (hopefully) displays what I would like. Say I have a database of pupil-teacher information from a school, two tables: one with pupil-class; the other class-teacher.
The first ...
1
vote
0answers
19 views
Software / Site for Comparison Lists
Wondering if anyone has a suggestion for either a website or a piece of software useful for recording information on things you're trying to compare?
Examples:
Looking for a house - would be nice to ...
0
votes
0answers
9 views
What backed databases is best to use with a react native app?
For my final year project, I will be developing website and database for a property management company case study.I have chosen react native to develop the front-end. What back-end technologies will ...
2
votes
1answer
40 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 ...
0
votes
0answers
10 views
Recommendations for website backend/frontend direction for SMB
I am looking for helpful suggestions for a website direction (or all-encompassing solution) for an online business that markets high value items on behalf of vendors, with medium-high monthly website ...
0
votes
0answers
9 views
Any software recommendation for data governance?
To ensure Data Governance is applied, any software recommendation for auditing 20 million rows of data in a database?
0
votes
0answers
8 views
Recomended database engine for write-intensive read-only use case
I a have a business case where i need to store a lot of messages for fixed amount of time. So let's assume
20 messages per second, each message is quite small and has at most 10-20 columns (about 100 ...
0
votes
0answers
17 views
PostgreSQL front end for repetitive import of Excel data
I work in a laboratory where an instrument pushes data into a PostgreSQL database residing on a virtual machine running Windows Server 2019. Our chemists have an Excel template, which they fill out ...
0
votes
0answers
4 views
Edit database tables - Firebird
I would like to know a convenient way to edit tables in a Firebird database. (such as:what client, preferably free application would be suitable for windows 10/64 bit)
0
votes
0answers
19 views
Free embedded database with EF Core & async I/O support
I'm looking for a free embedded database that has async I/O support to be used in a desktop (C#/.NET, WPF) application. I'll be using the Entity Framework Core ORM so a suitable provider also is ...
0
votes
0answers
2 views
Application to view extension (add-on) data stored in sqlite databases by Firefox
I have been searching for a Windows application to view data stored in sqlite databases created by Firefox extensions (aka add-ons/addons).
So far, I have tried:
Database Browser
Portable
DB Browser ...
0
votes
0answers
3 views
Java library to generate SQL INSERTS (DML) from JDBC ResultSet
Does anyone know a basic, no-nonsense Java library that will generate plain/standard SQL INSERT statements (as plain String) from a given JDBC ResultSet? Similar to what you can achieve when exporting ...
1
vote
0answers
8 views
What Python GUI software includes widgets that automate database transactions?
To give you an idea what I mean, decades ago, before I retired, I would have used Delphi for this type of desktop application. In that software you can connect a table display to a database table or a ...
0
votes
0answers
5 views
Recommendations for IoT project with Firebase
I need some recommendations for an IoT project.
There is several remote ESP32 with many variables. We want to see them on a web dashboard with current status and logging previous variables.
I have a ...
0
votes
0answers
5 views
Java library or tool for simple loading from a database
I work on a simulation program that reads data from a number of tables in a MySQL database. The database is read-only, and usually the queries are just SELECT * FROM .... Up to this point, the program ...
0
votes
0answers
11 views
Database for trading data in real time
I looking for recommendations to store and process (a little bit) tick market data from MT4 using ZMQ. I'm willing to store around 28 different instruments, but I have some questions regarding the ...
0
votes
0answers
7 views
Data explorer for Elasticsearch or Mongo
I'm working with a large data set that includes demographics information about people (voluntary survey participants). I'd like to be able to search through this data easily, to find people that match ...
0
votes
0answers
11 views
CMS,front end,database and backend on one hosting
I'm trying to create a website for a client and the requirements are:
CMS to change data on the website
backend to integrate payments and authorization
front end
database to store info about payments ...
0
votes
0answers
5 views
Gui based database version control for Postgres
As the title implies, I'm looking for a piece of software that would allow my non-programmer collegues to apply database versioning in the same way that for example django or alembic does.
The idea is ...
0
votes
2answers
24 views
What database can I use to store data from sensors?
I'm working on a project where experimental data is collected from a bunch of sensors. There are several ways the data is gathered and used:
Some metrics are collected on regular basis. For instance, ...
1
vote
0answers
10 views
Azure SQL Db to DB2 Sync
I need to automatically synchronize changes made in an Azure SQL database to our DB2 system. Whenever a change is made in Azure, DB2 should also be modified.
Azure DB creation is not started and table ...
0
votes
0answers
29 views
Serializing gamestate to database JavaFX in Intellij IDEA
I'm in a programming competition where I need to create a virtual board game. One of the requirements is serializing the game state to a database to load when a user opens the application again. Are ...
0
votes
0answers
6 views
Demographic augmented or virtual reality app to overlay job information on map or household buildings
I am looking for an augmented reality or virtual reality application where you can get a feel for the distribution of jobs across households in any area of the world you like by walking around, really ...
1
vote
0answers
6 views
Cloud service to send monthly email IoT sensor data
I am trying to develop a smart energy meter project in his the energy consumption and bill amount are calculated by Node mcu and sends data to cloud ,the cloud database should send this data to ...
3
votes
2answers
67 views
Business Software Recommendations
We are currently using a MsOffice Access database for our company jobs lists and reporting for the last 15 years. We need to replace this system with something more stable for larger amounts of data, ...
0
votes
0answers
19 views
Modern personal database solution for Windows
I currently use Simplenote to handle basic "databases" of a few hundred rows.
I'm looking to move away from Simplenote for these because:
This data is long-term and obstructs access to what ...
0
votes
1answer
27 views
SQL to Pyspark Conversion
Suppose you are given a .sql file containing 10,000 lines of SQL commands and you were told to convert them to PySpark.
What software would you use?
...the task I want to accomplish:
Somehow automate ...
1
vote
1answer
26 views
Choose database for multiple user desktop application
I am developing a Windows desktop application (.exe) for billing and inventory management using NetBeans. The application will run on multiple systems (10 - 12 on average), all connected in a wired or ...
1
vote
0answers
11 views
Is there any way to make a small dynamic site using cloud services with a cost cap?
By cloud services I mean something that provides or makes it possible to set up:
A "database": almost anything that provides centralised persistent state, see below. By centralised, I mean ...
1
vote
0answers
33 views
Tool for rapidly creating Web GUI for searching database on Intranet
I've a database with 20 million records in 5 tables and 150 fields. It grows by about 1%/day. We want to rapidly create an Intranet website where authenticated users can browse, filter, search and ...
1
vote
1answer
22 views
NoSQL database for highly structured, many-index, mission-critical data with lots of relationships
I'm trying to find an alternative to SQL which is very horizontally scalable. However, many NoSQL databases have some features I need missing from SQL, or some other weird quirks.
I am developing an ...
1
vote
0answers
8 views
What is a comprehensive integrated software stack for HR management, Learning Management, Financing and Procurement?
I'm looking for a comprehensive solution for Human Recourses integrated with a learning and courses provider management solution along with the finance management related to procurements, department ...
0
votes
0answers
8 views
No-server, document-oriented database
Does anyone know if there is a document-oriented database equivalent of sqlite, i.e. a software that would store data represented in JSON (or could, at least, import data from JSON files), but run ...
1
vote
2answers
18 views
Item organizer with support for image copy/pasting, list reordering, and tags
I'm looking for a web app to organize generic "items", that have,
a link
one or more images
some free-form text note
Ideally the web app would also support structured fields that I could ...
0
votes
0answers
20 views
Azure SQL Managed Instance Monitoring & Alerting
I am looking for recommendation for real time monitoring and alerting solution for Azure SQL Managed instances.
As per my research we can use:
1. Azure Monitor:
We can use it for basic telemetry ...
2
votes
1answer
46 views
Is there a lightweight SQL-capable database management software that doesn't try to be a server?
I'm looking for a program that's specifically not an SQL server. SQL servers seem to deal with permissions, connectivity, and all that jazz.
I just want a command line program that I can give an SQL ...
1
vote
0answers
10 views
Create (and make accessible) DBs to be accessed through API [closed]
We produce regularly some data sets that might be interesting for the proper audience.
The DBs have some thousand enties and the entries have 15 fields in a tree form:
{
"item": {
...
0
votes
1answer
18 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 ...
0
votes
0answers
6 views
Which wordpress plugins I should use to add a search form to my website which will query an external nosql database?
I need to add a search form in my wordpress website. This form will send a query to an external nosql database.
What plugins do I need ?
Thx
1
vote
1answer
9 views
Software for choosing the best output?
I am looking for a software which helps to choose between alternatives. The circumstances connected to social innovation, and the goal is to choose the best social innovation action based on several ...
1
vote
1answer
95 views
Simple but performant databases?
I'm looking for simple but performant databases, e.g. PostgreSQL is performant but complex and full of feature, while lowdb is simple but not very performant.
So either a single list of DBs with good ...
1
vote
0answers
9 views
An RSS aggregator for Linux with database or API?
I'm quite impressed with FeedReader to the point that I don't want to switch, but I now see that there's no further development with it. I expect it soon to be deprecated.
In any event, I'm looking ...
0
votes
0answers
11 views
What database to use for high concurrency read and write
I am collecting live stream data by using SDK inside apps Since this SDK is used by a lot of customers we end up getting large number of events 500Million per day at peak concurrency of upto 10k
The ...
1
vote
0answers
19 views
Which database is best suited for store GRID data?
We work with meteorology data in grid files. Each file is a 2d-array of latitude longitude grid of some meteo parameter (presepetaton, temperature or wind). We need to store this grid files in DB for ...
0
votes
0answers
11 views
NewSQL Database with remote read functionality
I am trying to perform deep learning on very large datasets which have to be stored in a NewSQL database because it has to be distributed. However, for the training process, I currently import the ...
0
votes
1answer
15 views
What api/database can I use in javascript client side webapps that reads the data from an online stored file and optionally caches locally
I have a small html/javascript only webapplication that runs client-side only. There is no backend (side from the files hosted on a webserver of course). My app does need to lookup a few fields though,...
1
vote
0answers
11 views
Web data entry forms from database tables
Is there any development framework that, having a database, tables, relationships,
take the tables as inputs and generates web data entry forms to edit the records,
AND provides tools to BROWSE, ADD, ...
0
votes
0answers
6 views
A database that is highly optimised for sequential read and writes that interfaces to Python
I'm doing a Monte Carlo study in which I am doing two things asynchronously:
Generating virtual scenarios (and storing them)
Running them through an algorithm (loading the virtual scenarios and then ...