Got confused how i solve this issue multiple select or linked table?
Reddit » Database
by /u/FutureLife777
7h ago
I am not expert in database design,hope someone able to answer what i should do. situtation is i need to creat a database for book i am collected, book i read, book i will ready, and group by category and need to tag them. curently creat one main table in main table/base - i list all the books name,add author name, add main category,add book tag individually in column. and filter that main table and save view by book i read, by category i want see. ​ ​ i saw airtable/nocodb/baserow have feature to link table: question is: what is the benefit i will get in future if i creat a separate - author ..read more
Visit website
Using a data warehouse (Snowflake) for application's fast access to read only data.
Reddit » Database
by /u/Altaflux
11h ago
We are facing a requirement we need to bring a data warehouse into our ecosystem. We are currently evaluating Snowflake as our primary choice. The business has an expectation that we should be able to not only run reports and analytical queries on the data warehouse (which of course is its specialty), but that they also want applications to be able to connect into it and read customer's data stored on it. The type of queries the applications are expected to execute are fast, and simple queries that will be done continuously through the day, mostly queries that retrieve the customer's general ..read more
Visit website
Whats the difference between "one" and "one and only one" cardinality? I'm so confused.
Reddit » Database
by /u/__Acedia_
18h ago
submitted by /u/__Acedia_ [visit reddit] [comments ..read more
Visit website
Is it difficult to learn SAS with limited math skills for job purposes?
Reddit » Database
by /u/Ok-Road5378
1d ago
Hey everyone, I need to learn SAS for job-related reasons. I'll be dealing with a lot of population numbers. But must admit I was bad at math in school. My understanding mostly covers basic statistics, such as interpreting charts and diagrams. Do you think it would be challenging for someone with my background to pick up SAS effectively? I'd appreciate any insights or experiences you might have. Thanks a lot! submitted by /u/Ok-Road5378 [visit reddit] [comments ..read more
Visit website
Data model review: how does this look?
Reddit » Database
by /u/volkxx
1d ago
submitted by /u/volkxx [visit reddit] [comments ..read more
Visit website
Does this look normalized to 3NF? Need help with class project.
Reddit » Database
by /u/volkxx
2d ago
submitted by /u/volkxx [visit reddit] [comments ..read more
Visit website
Help with database design for discord bot
Reddit » Database
by /u/aProgrammerHasNoName
2d ago
hi, im a beginner and im building a discord bot and i need help with database design for plugins/subplugins. the structure i have thought of. a plugin may or may not have configs, subplugins or values example of plugin with only values: - auto_message: each value is defines a message to send at X interval example of plugin with only configs: - welcome: config stores the message to send and the channel to send it when a member joins a server example of plugin with subpluggins: moderation ├── lockdown ├── mute_ban ├── appeals configs holds like the settings or general parameters. while valu ..read more
Visit website
EERD Assistance!
Reddit » Database
by /u/ATGravy
2d ago
Hello all! Currently I'm learning database design and doing work on extended entity-relational models, I'm having issues understanding a problem. Any experts here I can message and try to get some advice? submitted by /u/ATGravy [visit reddit] [comments ..read more
Visit website
Why Database is faster than spreadsheet?
Reddit » Database
by /u/_praba
3d ago
I have googled little to find an answer for this and things i understood are, how the data stored on the memory/disk - database stores data in b tree, hashes, heap, etc. But how spreadsheets are stored on disk? Easy manipulation of data since database stores data in structure way (atleast the structured DBs) such as each column as specific type (int, string, timestamp etc), where spreadsheet has unique cell mechanism, each cell is unique and can be typed any number or string or formula. I have read some difference through internet and could somebody help me to the conclusion with enough expla ..read more
Visit website
Storing chat history
Reddit » Database
by /u/penguins_world
3d ago
I’m looking for a database to store chat histories between users and chat bots. I would like to store things like message timestamp, message text, sender & recipient ids, upvote & downvote counts. Message text has no maximum length limit. There will be around 500 users sending about 10 messages a day. Average message size is 3 kB. I will build a system on top of the database to generate reports to capture chat bot response quality. Ex: “Show me query/response pairs from the past 3 months where the response received downvotes.” What kind of database(s) should I use? Should I store ever ..read more
Visit website

Follow Reddit » Database on FeedSpot

Continue with Google
Continue with Apple
OR