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
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
Reddit » Database
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
Reddit » Database
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
Reddit » Database
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
Reddit » Database
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
Reddit » Database
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
Reddit » Database
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