HS, Code, etc: Building databases?

[PsychoSkitz]

What kind of knowledge does this require?

Anything besides SQL or is that the main one to be concerned about?

Thanks.

 

[HappyScrappy]

a database is just a file on your computer. a database server is the software that then makes accessing and maintaing this file more efficient and faster.
it would depend what database you are using, but yes, if you have a SQL server, then knowing SQL will allow you to make tables, put data in, and pull data out and all that stuff between as well.

what it doesn't do is help you maintain the server or get it installed. some are easy, others not so much (compare mySQL to Oracle, to MS SQL Server 2K).

the only real thing that would likely be hard (aside from getting it up and going), is building the database and knowing how database layouts work (foreign keys and such are where it starts to get interesting).

 

[Code]

Do you mean building a custom db, the tables, rows and columns from scratch?

If you just mean getting some simple db for a webpage, not very hard at all.

You'd need to know sql and java or perl.

to be honest, if you're smart enough to read some FAQs and README's, you could build something like this in 24 hours or so of reading and playing around.

But if you're talking about something for heavy duty usage, then you'd need some programming skills, indepth knowledge of the target platform and a schlew of other skills.

 

[circusgirl]

For a one-person Microsoft Access DB, get a standard comp sci database textbook which will teach youthe principles behind good DB design and also basic SQL. The web is good for troubleshooting, with some creative googling. My DB skills are quite basic so I can't say any more.

Write your nice front-end in VB . Just my personal preference there...

 

[rotovibe]

What are you going to do with it?
How are you going to input data?

anyway:
Learn SQL
Learn how to normalize data
start with SQL server, very easy to use. 2000 has RAD tools and query analizers to check your SQL statements.
PostGreSQL is also a good one but might be too steep a learning curve for you right now. What's good about it is it's free
learn Inner and outer joins

 

[Puc]

use msaccess.

it is a wonderful learning tool (and fine sql db for small apps)

draw lines and connect tables... then look at the sql that is generated for your queries... it is hella easy to learn that way...

the real trouble is trying to find a file upload module that works in livewire on old school netscape server... fuckerss... i hate computers...

 

[HappyScrappy]

the real trouble is trying to find a file upload module that works in livewire on old school netscape server... fuckerss... i hate computers...

find?

whatever happened to "write"?

and yeah, if you have a very basic site that won't have many simultaneous users, then MSAccess is fine (also assuming that your server OS is chill with that - again, it is just a file, so you can write your own to hit it, but if on Windows then they have shit built in for that).

 

[rotovibe]

ODBC

 

[Puc]

find?

whatever happened to "write"?

and yeah, if you have a very basic site that won't have many simultaneous users, then MSAccess is fine (also assuming that your server OS is chill with that - again, it is just a file, so you can write your own to hit it, but if on Windows then they have shit built in for that).

this site is mired in legacy livewire ssjs.... SO, i cannot write something that the internal IT staff cannot maintain. I cannot just go and throw a java servlet together or write a cgi. and LiveWire does not support http uploads, at least, i don't think it does, though i am often wrong... also, since i am hourly i cannot justify writing one..