118 questions
-2
votes
2
answers
351
views
Why can't my laravel database be found now even if I had already used it a few days ago?
I'm new to using the laravel framework, and I'm struggling in starting my project due to several problems I've encountered while setting up. I'm currently using Linux as my command prompt and Xampp ...
- 1
1
vote
0
answers
28
views
Databases Manager Switching Databases
In my C# ASP.NET MVC project, I have an issue where the database manager switches to the wrong database. This happens if more than one session is running and the two sessions are using different ...
1
vote
1
answer
1k
views
Struggling with Prisma schema setup for many-to-many relationships on MongoDB
I'm trying to create schemas using PrismaORM with MongoDB, and I'm facing an issue with establishing a many-to-many relationship between User and Post models. My goal is to establish a relation ...
0
votes
0
answers
63
views
Solr reindex using Python
I am planning to use Solr as a quasi-database to provide fast search functionality for text data. The maximum expected number of records is around 1 million, ~50 KB each.
Additionally, a relatively ...
- 9
1
vote
1
answer
63
views
MongoDB $match seems to not working in aggregation
I have chat, admin,user and message entities. chat has reference of user and admin, message has reference on chat. Message has boolean property called viewed. So I am trying to get chats for admin ...
0
votes
1
answer
764
views
How to Baseline an sql script so that it won't show in the pending migrations in flyway
I have an existing postgresql database. I am trying to apply version control tool like flyway. I am using desktop app community version 6.6.1.0. I am trying to create a baseline script from here. But ...
-2
votes
1
answer
1k
views
Strategies for reducing/shrinking size of Azure SQL Database
I have a Azure SQL Database that's been operational for around 5 years, and is now approaching 300GB in size.
The bulk of the data is in a table with around 4 millions rows. One of the columns of that ...
- 85
0
votes
0
answers
115
views
RESTful api for database management
I have a restful api pet project and I thought I could make it better for others to use.
I'm not entirely sure about the applicability of such api but the question is whether it is supposed to manage ...
-2
votes
1
answer
463
views
Whats the best way to sort and search for similar embeddings for facial recognition
I'm planning on making a rather large database of faces/embeddings. I want to know whats the best way to sort my list of embeddings and I also want to know what's the best way to search my list for ...
- 67
-3
votes
1
answer
57
views
Undefined reference error along with exit status error when trying to call function in database management system
So I am trying to call a function which creates an assessment class object within the newStudent function. Ideallly the aim is for the newStudent function to run and after it reaches level selection ...
- 1
0
votes
0
answers
28
views
C++ Database skipping inputs [duplicate]
I was wondering if anyone could help me. I am working on a database management system and when I try to test out adding a new student. The program will randomly skip inputs and go straight to the next ...
- 1
0
votes
1
answer
107
views
Database Management - Should I use multiple databases?
I have an issue with the planning of my program. I am not sure what I should do.
Here my idea:
The program has users, the users can create persons, those persons have many attributes and every user ...
5
votes
2
answers
7k
views
Can I use firebase for only auth and any other SQL database to store other user data?
Basically I am building a social media type app. I want to manage the auth using firebase firestore (as It is easier) and the contents posted by the user in any other SQL database. Like, if the user ...
0
votes
1
answer
662
views
Best practices for managing changelogs from different applications
We have an API application with 2 REST endpoints, and 2 separate applications writing (independent) tables to the same database to serve as backend for these 2 REST endpoints. You can think of this as ...
- 1
-5
votes
1
answer
122
views
How to join each order with its price? [closed]
I have two tables named PRICES and ORDERS.
PRICES
Product_ID
price
1
50
2
100
ORDERS
CUSTOMER_ID
Product_ID
QUANTITY
123
1
3
456
2
5
789
2
2
327
1
7
I want to join these two tables to get below ...
- 1