Reddit » Database
177 FOLLOWERS
This subreddit is for news, information and general discussion related to various Databases. Share insights on database startups, learn new skills, discuss problems with nested loops when executing SQL queries, and ask about MySQL 8.0 replication.
Reddit » Database
2h ago
databases that actually have a decent GUI as opposed to just doing things via the console?
submitted by /u/savant78
[visit reddit] [comments ..read more
Reddit » Database
12h ago
In my React.js application I have a list of todos like this and their order can be changed
Todo 1
Todo 2
Todo 3
Let's say I move the Todo 3 to top, Now the list becomes
Todo 3
Todo 1
Todo 2
I want to persist the order in DB. How can I achieve this? I am using MySQL
submitted by /u/Taka-tak
[visit reddit] [comments ..read more
Reddit » Database
12h ago
If you're interested in distributed databases there is a free virtual event next week.
r/YugabyteDB's Distributed SQL Summit (DSS) Asia (April 24th) is aimed at people interested in adopting a modern data ecosystem and simplifying their database modernization.
You can find out more and register here➡️https://events.ringcentral.com/canvas/events/distributed-sql-summit-asia-2024/registration
submitted by /u/Yugabeing1
[visit reddit] [comments ..read more
Reddit » Database
20h ago
Hello.
I am a complete beginner and know very little about databases, but I would like to read about it and learn.
I have done some internet research on books and manuals for beginners, and titles like "Designing data intensive applications", "Database internals" and "Mysql crash course" have come up. However, by reading the book description, they all seem to be business-oriented. While my interest in databases is purely to learn how to store data in a way that makes it easy to compare information (I suppose then I should learn about SPQL?), for academic research.
Any recommendations or advic ..read more
Reddit » Database
23h ago
I am building an inventory management SaaS for mobile and web.
I am stuck between if I should go for Approach 1: A Database per organisation Vs Approach 2: One database shared between all organisations where each record is identified by an organisation id
My analysis so far is, Approach 1: - data isolated completely (peace of mind) - customer with low data will not be affected by an adjacent high data customer - moving the db around to different server can get easy - though not an intention, can convert to a custom solution at later point
have no idea about scalability- is it difficult?
mana ..read more
Reddit » Database
1d ago
I am building an app in Maui and was going to use SQLite as the database. I want to be able to also expand this app to ASP.net and possibly a Windows application at a later date.
I want to use SQLite as the database and want to keep it as independent as I can from the main application. So down the road I can add in a different DB if I need to .
I was reading the Maui docs and they suggest using the sqlite-net-pcl nuget package as the ORM, possibly because it is tailored for mobile apps? But the problem I see with this is I wouldn't be able to use this ORM for ASP.net or another framework that ..read more
Reddit » Database
1d ago
I've been researching a lot about sequential clustered indexes vs random (guids) and why sequential clustered indexes are more performant when it comes to page splitting and space used in pages. The one thing I can't wrap my head around is how sequential clustered indexes reduce page splits and utilize more page space. My understanding is if you use an auto increment clustered index and the fill factor is 100, all pages will be full (given no deletes) and there will be no page splits. I found a good article/visualization here - Visualizing the impact of ordered vs. random index insertion ..read more
Reddit » Database
2d ago
So I was assigned to make a payroll management system, and my first task was to create an ERD out of it.
i would just like to know if what I'm doing is right? Or am I missing some entities or attributes? It's just a simple payroll management system.
Any help would be appreciated thanks !
https://preview.redd.it/drp4kewzpruc1.png?width=1212&format=png&auto=webp&s=0e504f6bcd6ca424e48d5ed2aa7c9fe4f974f6d7
submitted by /u/9342134o_C
[visit reddit] [comments ..read more
Reddit » Database
2d ago
I was looking for a way to create an ERD that can also get generated into html structure that can be navigated. I saw what Dataedo can do, which looks really amazing. But their pricing seems very high, and I don't see that I can purchase just the ER diagram tool.
Are there any similar tools/vendors that can do something like what Dataedo does? What is important is that I can edit the description of tables/columns/objects (etc) in the XML files and then maybe use a tool to generate the HTML that can be served locally or thrown into a web app in Azure or something.
submitted by /u/Genuine-User ..read more