• shikozel
  • Beginner
  • Beginner
  • shikozel
  • Posts: 49

Post 3+ Months Ago

What is the difference between my sql,ms sql,microsoft access?
when do i use each one?
  • twiztit_momma
  • Proficient
  • Proficient
  • User avatar
  • Posts: 346
  • Loc: SanLeon Tx

Post 3+ Months Ago

http://avillagewetrust.com/Computers/Mi ... /index.htl
<~~~~ great information
  • _Leo_
  • Proficient
  • Proficient
  • User avatar
  • Posts: 279
  • Loc: Buenos Aires, Argentina

Post 3+ Months Ago

The first difference that comes up right away, is the software organization or company that makes the database engine:

PostgreSQL -> The PostgreSQL Global Development Group
MSSQL (and access) -> Micro$oft Corp.
Oracle -> Oracle Corp.
DB2 -> IBM Corp.

All of those are database engines supporting SQL (a standard query language). (To be honest, MS Access is not an engine).

You can think of these engines like server for storing a retrieving information. To do that, all you have to know is "speak" SQL. You will use SQL for telling the server to store a set of data (ie: a large telephone list), then you will use SQL for telling the server to give you a sub-set of data (ie: all telephone numbers starting with 555).

Which engine you are going to use depends on a bunch of things. Which one is available to you (MySQL and PostgreSQL are free software. You have to pay for using the others). Which one is suitable for the task you need to address (How many millon of querys at day are you going to make?)

For using such database engines in a web application, you will need a webserver with scripting support (PHP, Java, ASP, etc) and a database server to connect to. The connection is made from de webserver to the database server and it could be the same machine.

Hope it helps,

Post Information

  • Total Posts in this topic: 3 posts
  • Users browsing this forum: No registered users and 36 guests
  • You cannot post new topics in this forum
  • You cannot reply to topics in this forum
  • You cannot edit your posts in this forum
  • You cannot delete your posts in this forum
  • You cannot post attachments in this forum

© 1998-2017. Ozzu® is a registered trademark of Unmelted, LLC.