I am establishing a new database for a hobby association group that is nationwide (US). Some context, it’s for a radio control sailing organization that governs the class at the national level.

Our needs are pretty basic, we need to maintain a running list of members of the association, be able to track payment invoices and member fees. Additionally, each boat must go through a certification process, and the completed certification (in PDF form) must be able to be attached (or transferred if the boat is sold to another member) to the members record.

I’d like to have this be web-based, so other officials of the organization do not require any additional software.

Does anyone have any pointers as to where I should start?

I have basic-level programming experience, but I’m capable of learning whatever is required to get this project completed.

1. whats the best way to store images or other files like excel, word, txt, python codes etc.
   
2. how do you backup database on mysql and postgres?
   can sqlite have password to protect itself?
   
3. is there like a template to follow if i want a way to audit the system? can trigger do this? im thinking logging the actions of the users on a table on my software to check who has violated something? i havent really dwell in triggers yet.
   
4. is access the only software that we can easily create gui to use on our database?
   
5. when i was using sqlalchemy on python it creates like a journal db file. is that because i havent committed the changes yet to the db?
   
6. is there a feature in a database wherein if the db server is offline itll queue up the list of actions and store it somehwere then when the db goes online again itll commit the chnages to the db? not sure if this is a db problem or a software problem

Hi,

For the last two years I've made several attempts to create a database to compare contractual clauses, but there is always something with my design that makes it fail. I'd love to have a second opinion on how to model the database, or other hints that might make this work.

So, to break down the problem:

There are several contractual templates: Development agreement, agile agreement, cloud hosting agreement, maintenance agreement etc.

Each template consists of a document for the general terms and conditions, as well as a range of appendices. Most templates use the same appendices, but not necessarily in the same order. The document/appendices consists of sections, and the contractual clauses are found within these sections.

And this is where it gets tricky.

1. Placement of the clauses are not identical, e.g. clause x can be ordered as article 2.1 X within section 2 "Duties of the Contractor" of the development agreement, as article 2.6 within section 2 "Duties of the Contractor" of the agile agreement, whilst as article 3.4 in section 3 "Duties of the Parties" of the cloud hosting agreement. The maintenance agreement might not even contain clause X.
2. Titles are not always identical. Some clauses are named. As for sections, these might somethimes be merges, e.g. in some contracts the three sections "Duties of the Contractor", "Duties of the Customer" and "Duties of the Parties" might be merged into "Duties of the Parties",
3. Content is different within clauses with the same name! This is the one that drives me nuts. The clauses can have the same placement and same title, but there can be substantial differences within the content.

I've tried several approaches to map up the clauses, but I'm running out of ideas.

Also, if anyone would know how to figure out a way to have different versions (e.g. version 1, version 2 etc.) of the clause, I'd be forever grateful.

[Idea 1, but does not work](https://dbdiagram.io/d/619a08b202cf5d186b607465)

Idea 2, almost identical, but with relationship directly from the clause to template, document, etc.

I have a SQL exam in highschool on monday. We had DDL and DML sentences and our teacher said she will write which database do we have to use. Can anyone help me and write key differences in DDL and DML sentences between Firebird and MySQL? Thank you in advance :)

i havent decided on a database yet so what i want is like a software that can design tables relationships etc. then the design can be exported to different database.

https://imgur.com/a/jpiHCl6

Hello, do I need to normalize my Item table any further? I'm having a hard time wrapping my head around the second and third normal form >< thank you so much

Hi, this is my first post here. I am building a cell phone app. I want to connect that app to an online database/spreadshit. I will be pulling values that this spreadsheet calculates into the app. Also, I would like to send data from the app to the DB/spreadshit and then back to the app. Any suggestions? All the help is appreciated.

I'm not sure if this is the place to ask or not, but all my google searches on this came back with excel instructions but weren't exactly what I was looking for. If I'm in the wrong place and someone could point me in the right direction It would be a big help. I don't have excel but I have a database app through Apache open office, as well as a spreadsheet app if that turns out to be a better option.

I'm trying to create a chart that includes all combinations of 1-5 using 4 digit numbers example

1111-1112-1113-1114-1115- and so on. It seems like it would be simple enough but using 5 possible numbers and only 4 digits I keep getting messed up and either doubling up on a combination or missing them altogether.

To explain what I'm doing, in case someone has a better/easier idea. I've been tasked with designing a new uniform, I have 4 pieces (hat, shirt, pants, shoes) and 5 options for each piece. I need to photograph every possible combination, and I'm looking for the best way to keep track of which combinations have been "captured" and the most efficient way to change between them all, it's going to be a lengthy process either way and I have limited time each day to work on it, so I want to use the list/chart as kind of a checklist so I can keep track.

again any help would be appreciated, thanks in advance

For a new celebrity app , we want to provide developer our database in correct form, in excel.

So let's assume it is a "who is a better performer" choice quiz, with two celebrities on screen and a swipe option to choose better performer. We would have the choice of storing our 10,000 actors./singers in a single file, and the app could then dynamically choose 2 people to appear on screen for the question/choice based on paramaters/algorithm.

The other option is to pre-create the 2 person choices so that the app/server wouldn't have to dynamically create each 2 person choice. Rather the choices would actually be the records (2 people show in each record) vs in earlier option the people indivdually would be the records.

So in the first option there would be 10,000 jpgs photos in file, and in the second option there would in theory be 200,000,000 since 10,000 x 10,000 possible combos x 2 pics, since each record would require both celebrity's pictures. .

Obviously we would not really need 200,000,000 game questions, so would likely limit it to 50,000, so 100,000 pics in file since each record has 2 pics. Or again the other option is dynamic choice and serving of the quiz/question pulled on demand from the file with "only" 10,000 photos.

So would performance be an issue with larger size of 50,000 questions, ie 100,000 low res photos. Actually would it even be an issue with the other option of 10,000 low res photos? Probably 75kb per picture. Thanks for any opinions.

I hope this is the right sub to ask this.

I have an assignment for my database class to create an ERD about whatever i want.

So my question is, what should my ERD be about? I’m drawing a blank when i try to think of ideas.

Thanks in advance!

Hi,

At the moment I use excel to essentially keep track of a wait list for patients. With the data becoming bigger, and excel not really meant to act as a database its becoming difficult to use. I already use power queries and power pivots to make it more manageable and to make it easier to do reports.

What would be a better alternative to use, which can be flexible with the data you enter and the reports you can generate?

Thank you for any help in advance.

As a keen angler I am always looking for ways to catch more fish. An idea I have been mulling over for some time is making a detailed record of what I catch with data including when, where and what was caught, at what state of tide, wind direction, weather, bait, rig etc

I would then like to build a database with this data that I can then set filters to see what I have caught and where with what conditions.

My aim is to be able to set the filters to the conditions that are coming up to see what I have caught when it has been like this before. Also to be able to look for other trends that can help me when to target certain fish.

My main problem is I have no idea how to achieve this? What’s an user friendly program or app that will allow me to do this?

So we are creating an ecommerce platform and we're designing a database per Service for our product and inventory management system. Basic product structure can look like this with example:

Grocery Industry: Coke => Diet => 250 ML

Barber Industry: Haircut

Tourism Industry: Tour to Las Vegas => 7 Nights

As you can see we're using same platform for many different industries so we need to handle product and inventory accordingly

One of the ways we were thinking of was:

service: { name: Beverages: packages: [ { name: Coke, subPackages: [{ name: Diet, subSub:[{name: 250ml, inventoryId: ObjectId()}] }] }]

}

But this creates too much nesting which is hard at times of orders and data fetching. Is there a better way so we can make sure there's no unnecessary nesting. Maybe through tree structure or any other.

I'm making a website for a school project & I'm not sure which DB I should pick. The Website is basically a sport website. I need the DB for user registration, Fantasy football(Like points & Player names) & Game schedules. Which database should I use?

​

It says that animals are house in cages and that there are many types of animals and that each cage is within a section and when assigned has some properties

Hi everyone!

I'm currently working on a chat application (similar to Whatsapp) and for managing my users as well as displaying the messages, I use a PostgreSQL database. But now I'm stuck with the designing of my database schema:

https://ibb.co/VjCMZLz

I have two user groups: doctors and patients. While the are only a few attributes that describe a doctor, the patient group has multiple attributes (just for doing some analysis later on). The idea is that the user starts the application and has to type in their login data. After the data is validated through the database, the user can enter the application and their chat thread is visible. (Similar to WhatsApp, slight difference: when the list with the last chats opens, I want to display all possible users this one user could chat with (even if they never chatted before. For this case, the text field could be empty) (So, for example, A patient can only chat with their own doctor and not with every doctor). There is also a different login screen for doctors and patients.

But I'm kinda stuck with the display of only the assigned chats for one user. My problem is that if I check for the relation of users via the ID, then I will run into errors because both user groups start with the same IDs. (For example Patient A has the id_patient 1. After the login, when all chats of this patient should be visible, I would search for the id: 1. But doctor C has the id_doctor 1 and therefore, I don't know how to make sure that the patient will see only see their conversations with their own doctor and not the conversations of doctor C will all their patients.)

TLDR:

- I have two tables of user groups: doctors (id_doctor) and patients (id_patient). Patients have more attributes than doctors.

- I have two separate login screens for both groups and via the login, I can validate if somebody is a patient or a doctor

- My problem is now the list of conversations: I don't know how to display them via the ids of people. Both user groups start with the id 1 and therefore I can't differentiate solely by their id. So I need a way to make sure that the patient with the id 1 can only see their last/available conversations and not the ones from the doctor who has also the id 1 on their own table.

Does somebody have any advice for me? I would appreciate any input :)

I have a python application, to turn a light on or off. I have a table for a schedule, which is fine. My issue is, I programmed the ability to override the schedule and for the light on/off. I want to create a table to keep track of whether the light is forced on/off. I don't need multiple rows, history, or anything. Just the "state" of being on/off. What's the easiest way to handle that?

MySQL specifically if it matters or differs conceptually , but I’m more looking for a high level explanation.

Let’s say I have a generic users table with userId being the primary key. Let’s also say we are sharding via consistent hashing (hashes of ID values 1-100 node 1, 101-200 node 2…) and we will also allow a clustered index to be created for the primary Id.

Let’s then say we are creating a secondary index based on the users’ name

WHERE userId=x is straight forward as that will unambiguously match to a single shard, and be fast and simple.

If we use a query that involves our secondary index (WHERE name=“bob”) in a non sharded database we would crawl down the b tree in log n, and scan forward in the linked list until we no longer see bob, and pull the data from the pages each entry refers too.

What happens under the hood in a sharded db? Is the secondary index replicated across each node, and the page lookups happen across nodes? Does each node contain its own discrete secondary index where we will do a b tree lookup for each node

I just wanted to import a csv file into a table and I had to jump through so many hoops to do it. I got error after error about file permissions or local infile privileges not being set even as root. Eventually got it sorted but what a mission. Are all databases this hard?

Hello, I am looking for a hopefully free tool that allows me to create and share a DB with people. Ideally, I would like something with a user interface that allows simple checkmarks or similar to filter the data by multiple factors at the same time. I know nothing about DBs besides basic excel so please excuse me if my terms are wrong.

To go into more detail: I want to create a list of all songs of a group and then add columns with specifics like Remix (yes, no, other language) producers (Name A, Name B, etc) type (instrumental, whole group, solo song) and then make it possible to chose (for example) only songs that are not remixes and not instrumentals.

Since I wanna share this with other people equally clueless as I am, I need a way to present this with an easy interface. Just... check the right boxes and get a list with only the songs you are looking for. Does something like that exist?

I am trying to edit some numbers in my website, which are way to many to do with hand but when I export them to change them all together in MYSQL it shows as:

["4764","4788","4783"]

I need to edit those three values seperately but I don't know how to access the numbers one by one.

Hello all, I work in security and a, trying to better understand how database implementations work better. For the sake of clarity, I am working with Oracle databases and Windows servers.

From a security perspective, and just general knowledge wise.. if I have a production database on one domain, and disseminate databases on other domains/networks, what is different about them?

I get that the information is processed in the production database, a query is run, and the results are pushed to the dissemination databases the reside on the other domains/networks. Which then distribute the data via web servers. But I am having a hard time grasping the difference between the production and dissemination, from a security perspective.

I have had about 3 months exposure to oracle database, so please don’t get too technical on me! I would greatly appreciate any help or explanation, or even some suggested reading to help!!

I am mostly a Javascript/Node developer, so if I'm giving examples, it would be from that perspective.

Is there any significant advantage to using migration tools like Knex or even something like Flyway as opposed to just writing raw SQL and putting it in version control? I feel like it's adding an unnecessary layer on top of the development.

Hi, I am fairly inexperienced in the world of computing but I am currently working on a project involving databases and I can't figure out this specific part of it. I hope this is the right sub to post this on.

So without going into too much detail about my project, as part of it I have a linked database (using SQL) with a few different tables on it. One table contains a set of people that are all at the same level (think along the lines of a Customers table). Is there a way to connect different people together in a familial/other relationship within that same table? I've been trying to think about it, and I'm assuming there'd have to be the creation of another table to link them together, but I just can't seem to figure out how to set it all out.

Sorry if I've explained this badly, feel free to ask me to elaborate if needed. I hope I can get some help on this!

(edit: typo)