I'd like to set up a database with an API that other developers can use to make apps that can view and modify my database.
I'd like to keep my costs at a minimum.
I'd like to control the developers accessing my database, the apps accessing my database, and the end users accessing my database.
I want to ensure that the database is secure and restrict the modifications that can be made to my database - IE, I'd like to make sure that people don't add things to my database that don't belong, and I'd like to ensure that people don't add incomplete entries to my database, and I'd like to make sure that people don't delete entries such that they render other data illogical.
I have no experience with setting up a server or online database (although I have some experience with SQL/MySQL Workbench.) I was hoping people could answer these questions for me:
1 - Do I need to write my own server side code to do everything, or is there something magical I can do that allows me to avoid writing my own server side code?
Skip 1a and 1b if I don't need to write my own server side code...
1a - What language(s) should I use for my server side code? I know C, C++, Obj-C, Obj-C++, Java, JavaScript, and SQL. I've got nothing against learning more languages, I just provide that list so you might know which language would be easiest for me to learn for this.
1b - Are there hosting services where I can upload this server side code?
2 - I have a few old Macs laying around the house (a Mac Mini, a G4 tower, and a G5 tower,) that I feel I could use to host this database. Should I use them or some other hosting service? If I should use them, how would I go about doing so?
Thanks in advance! (This all pertains to the same topic as one that I had in iOS Programming yesterday, but I feel like the questions I wrote here have a much different approach to the root of the things I want done in my iOS app.)
I'd like to keep my costs at a minimum.
I'd like to control the developers accessing my database, the apps accessing my database, and the end users accessing my database.
I want to ensure that the database is secure and restrict the modifications that can be made to my database - IE, I'd like to make sure that people don't add things to my database that don't belong, and I'd like to ensure that people don't add incomplete entries to my database, and I'd like to make sure that people don't delete entries such that they render other data illogical.
I have no experience with setting up a server or online database (although I have some experience with SQL/MySQL Workbench.) I was hoping people could answer these questions for me:
1 - Do I need to write my own server side code to do everything, or is there something magical I can do that allows me to avoid writing my own server side code?
Skip 1a and 1b if I don't need to write my own server side code...
1a - What language(s) should I use for my server side code? I know C, C++, Obj-C, Obj-C++, Java, JavaScript, and SQL. I've got nothing against learning more languages, I just provide that list so you might know which language would be easiest for me to learn for this.
1b - Are there hosting services where I can upload this server side code?
2 - I have a few old Macs laying around the house (a Mac Mini, a G4 tower, and a G5 tower,) that I feel I could use to host this database. Should I use them or some other hosting service? If I should use them, how would I go about doing so?
Thanks in advance! (This all pertains to the same topic as one that I had in iOS Programming yesterday, but I feel like the questions I wrote here have a much different approach to the root of the things I want done in my iOS app.)