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
3
votes
1answer
37 views

Spatial search server, to quickly answer “What points near me?” requests

I have about a million points like this: Latitude Longitude Text (short text of less than 128 characters) I am writing an app that must quickly show what points are around the user. User: I am at ...
1
vote
3answers
4k views

Fast-to-set-up HSQLDB database management GUI

I am looking for a GUI to quickly check an HSQL (Hyper SQL) database. Requirements: Fast to set up Can be started from command line with filename as an argument See tables Run queries Open source
0
votes
1answer
37 views

What combination of toolsets is cost effective for hosting an intranet website?

Conditions: I need to be able to support a database that is small and multi-user access I need server-side and client-side programming/scripting I need it to be license free - or low cost, yet ...
2
votes
1answer
335 views

Hosted web platform for a small database application (back- and front-end)

I'm looking for a hosted database solution that allows you to define both the back-end (tables, views, relationships) as well as the front-end (forms, reports, ...). Both the number of tables as well ...
1
vote
1answer
73 views

File-based database: Sqlite, MongoDb or else?

I am looking for a file-based database solution, where the original inputs are in csv format. Key info: One complete dataset is a static collection of files. However, I will need to have multiple ...
7
votes
1answer
174 views

A Database Management System that understands Relational Algebra Queries

I am a Computer Science student and we are currently learning Relational Algebra. I wish to be able to write Relational Algebra Queries and test to see what they return. Thus, I am looking for a ...
0
votes
1answer
55 views

Secure data transfer (for DB/ETL)

Does anyone know of any tool, ETL suite or BI suite that enables safe and secure data transfer from one location to another, over internet to an offsite database in the cloud? Or, what approaches ...
2
votes
1answer
46 views

What application for storing data based on metadata, and retrieve it via metadata search?

In our institution we have a large database of observational data consisting in precipitation, temperature, elevation and a large number of other variables, coming from different projects and in ...
0
votes
1answer
31 views

Multiple application 'base' configuration definitions stored in…Enterprise Arch/CMDB/etc?

I'm trying to find software to put ~10 different software pieces of information. The pieces of information include the following for the 'base' install: intended tested operating system other pre-...
1
vote
1answer
55 views

Easy to use database software to maintain music inventory

A friend of mine - a typical babyboomer - has a very extensive music inventory, especially a lot of compilation albums. He used to maintain a database software program called Reflex. Every time he ...
1
vote
0answers
7 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 ...
1
vote
3answers
316 views

Which tool to use for SQL Server Database migrations and why as of 2017?

I want to know a tool to use for SQL Server Database migrations and why as of 2017, since I worry about this topic, so I can automate this process as much as possible. What do you think about Entity ...
0
votes
1answer
19 views

ETL tool and database recommendation for Stock Analysis

I am planning to work on an project that does analysis on the Stock prices. The daily data gets fetched from an API end point. Before running the analytics and predictions, this data needs to be ...
0
votes
0answers
14 views

What online/cloud databases can I use for Java desktop applications

I am trying to store customer repair request and complaints stored on a online database, so it can be shown on the sellers side. This will be done on my java desktop applications do you recommend any ...
0
votes
0answers
17 views

Offline REST DB

I am looking for an offline rest database so that I can provide server-side storage on my html pages without converting them to full stack server-side applications. It can be SQL or JSON based but ...
1
vote
1answer
31 views

Evernote with custom properties. Notion with full offline support

I need a desktop RDBMS to conveniently manage a bundle of rich text notes -- CRUD, adding tags, search inside notes, backups, etc. In a way, I need a light, abridged, desktop only version of Evernote ...
3
votes
1answer
71 views

C# What is the best free and reliable database solution for storing configuration?

I am about to choose a database solution for my c# project: to store simple configuration at first, bools, ints, paths etc. to store lots of small text blocks in the future probably to store small ...
2
votes
4answers
128 views

Multi-user data editing software (think Excel/Access) with chart support?

I have a client (large corporation) with a broken Excel document where their staff enter some numbers, which are then displayed in some charts (like a sales dashboard). There is some validation on the ...
0
votes
0answers
12 views

Database with documents full text search anad tags searchs (java better)

Hi I am looking for a database or document base, with the feature to store documents (pdfs, words....) and do full text search in the content. Also search by tag and other columns that i will agree to ...
2
votes
3answers
604 views

Is there any database which can be accessed offline without internet connection?

we need to design web and mobile app solution for a client. the requirements are following Application with offline capabilities, that will sync with cloud when you reconnect to the internet, but the ...
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
17 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
24 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
2answers
55 views

Need a database for a single-user app to sync data across computers without storing on the internet

Need suggestions for a database. I'm tasked to write a C# desktop application for a small business. The business owner does not want his data to be stored on the internet. He has two desktop computers....
1
vote
1answer
24 views

create reports/queries via a GUI that respect database relations (replace oracle discoverer)

I am looking for a tool to replace oracle discoverer. The main goal is to support non-technical users in their reporting. Despite other functionalities the main once are as follows 1) The must have ...
0
votes
1answer
119 views

What's the difference between Shared Preferences (Android) and NoSQL? Why would I choose NoSQL for simple XML storage?

I am storing simple data and my boss is keen on using a key-value pair database to do so. The developer before me chose SnappyDB, which is a NoSQL database similar to Mongo, Couch, and Redis. ...
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 ...
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 ...
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
1answer
21 views

Store json data for elaboration

Some remote data organized in a Mysql database should be replicated locally. Only some tables and only a few rows inside those tables are important locally, so it is overkill to create a complete ...
0
votes
2answers
30 views

Recommendations for software, library or framework to delta large CSV Files

I am currently investigating what is out there that would quickly and efficiently compare and produce a delta from CSV Files. What I am dealing with is data that is outputted from Sybase ASE. These ...
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 ...
1
vote
2answers
20 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
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 ...
0
votes
2answers
68 views

What database should I use for a social media app?

I am planning on developing a social media app but have no idea what database to use. I have been learning to develop android apps and the databases that I have used so far are only SQLite and ...
2
votes
1answer
45 views

Mobile Friendly Data Entry App

I am trying to create a data entry "app" to collect daily readings across our site. Here are the three biggest constraints: Software - ideally, we would use some software within the Microsoft 365 ...
0
votes
0answers
11 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 ...
2
votes
1answer
50 views

Easy Windows GUI to edit content of MySQL tables (must be much simpler than Workbench/etc)

Looking for a recommendation on a MySQL DB manager with easy and slick UI. It needs to be able to handle direct queries, visually edit tables and databases mostly with mouse clicks. Kinda looking for ...
1
vote
2answers
69 views

I'm developing an android food ordering app, what software do I use to send the order to another device?

I'm making a project and I need to find a way to submit a food order to another device, like McDonald's does. Like when a customer chooses their order and they submit it to the kitchen for the food to ...
0
votes
1answer
16 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,...
4
votes
4answers
279 views

Form builder with local data storage, Mac compatible

I have a series of records, each of which has the same fields. I’d like to build a form interface to start editing these records, as managing them in a text file is unwieldy. Simply having a few ...
0
votes
0answers
25 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
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
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
5 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 ...
0
votes
2answers
39 views

Reverse Email Address Lookup and Email Validation

What is the best site or tool to do email address validation or a reverse lookup for the name attached to that email. I am working in a database for a company and they need to verify who their leads ...
1
vote
1answer
22 views

Does any SQL database / CMS let you edit the data in spreadsheet / worksheet mode? (Lotus Approach did, but it's long dead.)

Can you fall in love with a database? I did: Lotus Approach. Alas, it no longer exists. PhpMyAdmin is not the same. Can any SQL database / CMS let us: work the backend data (the "worksheet"...
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 ...

1
2 3 4 5
12