Online Database

Grab a cheap webhost. All sorted :) from R15 a month should cover your needs.
 
Depends on your needs. Being web based you will need to learn how to use the command line. You can also install PHP frontends to handle interaction with the db.
 
Most online hosts provide a frontend, like phpMyAdmin, for MySQL. If you are looking for an embedded/standalone db like Access, I recommend SQLite.
 
If you understand SQL syntax, then you will get along just fine with MySQL for coding projects. If you just want a database to access from your control panel, then phpMyAdmin will also prove helpful.
 
What do you want to use the database for? There may be a easier option than learning straight SQL.
 
stay away from ms access

and I'm pretty sure the OP loves the GUI much more and doesn't know much SQL syntax. Keep to mySQL or MS SQL (if your host supports it)

However, I'd only recommend sqlLite if you're writing stand alone desktop applications. It's robust and free to use and doesn't require additional database software being installed on the client machine, however, for a web based enviroment, your best bet is mysql and mssql
 
I decided to bring this thread back to life to avoid starting another thread on a similar topic :p

but my dad is wanting me to learn mySQL so I wanna ask how easy is to pick up and start making a decent database? and then on a different topic he was also wanting me to learn how to make programs in VB and Java that can communicate between the 2 of them over the network which apparently you'd make use of winsock to do? Any chance someone can point me in the right direction with these 2 :)

Thanx in advance
S1ght
 
S1ght said:
I decided to bring this thread back to life to avoid starting another thread on a similar topic :p

but my dad is wanting me to learn mySQL so I wanna ask how easy is to pick up and start making a decent database? and then on a different topic he was also wanting me to learn how to make programs in VB and Java that can communicate between the 2 of them over the network which apparently you'd make use of winsock to do? Any chance someone can point me in the right direction with these 2 :)

Thanx in advance
S1ght
Click to expand...

Learning mySQL is as easy as breathing. However, I would want you to start out with MSSQL. No, not because I'm a fanboi. It's just I don't have the mySQL experience and know what they offer in terms of ERD's and relational database design (which makes MSSQL a dream to work with)

Basically you need to start out understanding relational database design. A lot of people make the mistake starting out and don't learn it until they're a few projects into the thing or at a real world job. Start out early. That's why I said NO MS Access ;)

Learn to love INNER JOIN's. Learn the difference between a LEFT OUTER JOIN etc

Does your old man want you to make the programs communicate physically with each other? Doing what exactly? (There needs to be a set purpose, making 2 programs communicate via winsock is piss easy but you don't use a spoon to cut your steak, so a little more detail would be awesome)

Winsock is a bit old-school IMO but still has its uses. If the 2 programs just need to communicate somehow with a database (display same data etc) that's easy enough too. If they need to communicate between the two, you need to think of failover's as well.

What if one machine is down if the other one tries to communicate some valuable data?

I reckon instead of winsock's (in that case) you should look at Message Queues. (MSMQ's)


Yes Yes, I love M$ long time. But that's where my bread+butter is :D
 
AcidRaZor said:
Yes Yes, I love M$ long time. But that's where my bread+butter is :D
Click to expand...

Looks like me and you are in the same boat... :p

If you're building web applications (using ASP.NET or J2EE), an alternative to the communication layer is XML Web Services. These communicate by passing SOAP messages to the calling application and are platform independent and, if passed over an SSL connection, quite secure.
 
AcidRaZor said:
Learning mySQL is as easy as breathing. However, I would want you to start out with MSSQL. No, not because I'm a fanboi. It's just I don't have the mySQL experience and know what they offer in terms of ERD's and relational database design (which makes MSSQL a dream to work with)

Basically you need to start out understanding relational database design. A lot of people make the mistake starting out and don't learn it until they're a few projects into the thing or at a real world job. Start out early. That's why I said NO MS Access ;)

Learn to love INNER JOIN's. Learn the difference between a LEFT OUTER JOIN etc

Does your old man want you to make the programs communicate physically with each other? Doing what exactly? (There needs to be a set purpose, making 2 programs communicate via winsock is piss easy but you don't use a spoon to cut your steak, so a little more detail would be awesome)

Winsock is a bit old-school IMO but still has its uses. If the 2 programs just need to communicate somehow with a database (display same data etc) that's easy enough too. If they need to communicate between the two, you need to think of failover's as well.

What if one machine is down if the other one tries to communicate some valuable data?

I reckon instead of winsock's (in that case) you should look at Message Queues. (MSMQ's)


Yes Yes, I love M$ long time. But that's where my bread+butter is :D
Click to expand...

hmm...I see :) I figured for something like databases I'd have to go learn more than just the code for mySQL, looks like I'm gonna have to go research a bit. You see we do database design and implementation this semester but my dad somehow wants me to learn it all in the next month...I have no idea what the purpose of the 2 programs communicating with each other, he was a lil vague about this 1 :rolleyes:

So are mySQL and MSSQL very similar? Say if you know 1 you can do the other? Or should I look at learning both?
 
S1ght said:
hmm...I see :) I figured for something like databases I'd have to go learn more than just the code for mySQL, looks like I'm gonna have to go research a bit. You see we do database design and implementation this semester but my dad somehow wants me to learn it all in the next month...I have no idea what the purpose of the 2 programs communicating with each other, he was a lil vague about this 1 :rolleyes:

So are mySQL and MSSQL very similar? Say if you know 1 you can do the other? Or should I look at learning both?
Click to expand...

If you know one you can do the other. There's just a few syntax niggles between the two.

Same reasoning behind, "If you know one programming language you can do another"

It's just syntax that changes, the logic is the tough part to get right ;)
 
You must log in or register to reply here.
Back
Top
Sign up to the MyBroadband newsletter
X