spacewaste
Apr 1 2005, 02:02 AM
| | MySQL is also the most compatible for most server programs and premade scripts 
Also it is the default other then Post for most hosting servers...AKA us |
Reply
minnieadkins
Apr 1 2005, 03:53 PM
I'm taking a course on php and mysql, and so far I'm very interested in it. I just can't seem to get the "hang" of it. I never really used a database and I'm not too sure how to "setup" a database on ..let's say...even astahost. So far we've set up localhosts and that's about it. Just learning, but so far I enjoy MySQl and it seems to be a very popular database. I'm just curious how everyone uses databases and php to make sites that allow a static menu to be displayed. Guess it's something to do with drop tables and such. Once I get the "hang" of this I'm sure I'll probably stick with MySQL.
Reply
Coach
Apr 5 2005, 05:13 PM
I’m starting to learn php and MySQL. I chose MySQL for his following features: QUOTE Taken from the Paul DuBois’s book: MySQLSpeed: MySQL is the fastest database you can get, look at http://www.mysql.com/bechmark.html. Easy to use: MySQL is a simple database but it’s a high performance too. Query language support: MySQL understands SQL, the language of choice for all modern databases systems. Capability: Clients can use multiple databases simultaneously, you can access it using several interfaces, a variety of programming interfaces are available for several languages like C, Perl, Java, PHP and Python, and much more. Connectivity and security: MySQL is fully networked, and databases can be accessed from anywhere on the Internet, so you can share you data with anyone, anywhere; but it has access control so that people who shouldn’t see your data can’t. And now to provide additional security, MySQL supports encrypted connections with the Secure Sockets Layer (SSL) protocol. Portability: MySQL runs on many varieties of UNIX, as well as on other non-UNIX systems, such as Windows and OS/2. Small size: MySQL has a modest distribution size, specially compared with certain commercial database system. Availability and cost: MySQL is an Open Source project, freely available under the terms of the GNU General Public Language (GLP). This means that MySQL is free for most in-house uses. Open distribution: MySQL is easy to obtain, just using your Web browser and you can get the source code also. Finally, it is obvious that the popularity of MySQL has also been aided by the existence of phpMyAdmin, the industry-standard administration tool that makes database management easy for both the experienced developer and the novice, and this is what is helping me very much.
Reply
Analyst
Apr 18 2005, 08:40 AM
With Databases it really is a case of "horses for courses" MySQL is everywhere where Linux and LAMP (Linux,Apache,MySQL,PHP and or Perl) exist. But it is not the most powerful of the free database offerings. In Order of Simplicity of Data Structure for "Free" Databases the choice would be CSV File | XML file | basicaly text files MySQL PostGreSQL SQL Server Express (Win32 only) -note 4G data limit Of the list the latter two are the hardest to learm, but most powerful (i.e including stored procedures) Regards
Reply
miCRoSCoPiC^eaRthLinG
Apr 18 2005, 01:50 PM
MySQL from version 5 onwards does support Stored Procedures. (Its already out as a developer version - but not a stable release yet)...
Reply
vhortex
Apr 23 2005, 07:34 AM
QUOTE(microscopic^earthling @ Apr 18 2005, 09:50 PM) MySQL from version 5 onwards does support Stored Procedures. (Its already out as a developer version - but not a stable release yet)... I'll confirm on that also... MySQL 5 now acts like ORACLE and it now have most of the capability that ORACLE have. I am using that as of now and I am proud that I have save at least 30% of coding time and gain at least 25% or so of speed boost from the same program that we are developing. We also managed to have a greater connection pool and believed it or not, our MySQL server is fully operational and is just installed on a pentium II pc with 256 mB memory using a red hat linux console mode. Those other databases wont even get installed on a pentium II 300 that we are currently using now.
Reply
emersonbrum
Apr 25 2005, 11:20 PM
All right, Mysql is free and open source, but when you need help or take out a doubt with the support who's gonna help you as faster as possible ? In my opinion ORACLE is the best of because it's faster than MySQL you can administrate it and programming for any kind of troubles Even Though you need a wide space you can set how much you´re gonna use, different than Mysql and the most important thing the support is 24x7
Reply
vhortex
May 4 2005, 02:15 AM
QUOTE(emersonbrum @ Apr 26 2005, 07:20 AM) All right, Mysql is free and open source, but when you need help or take out a doubt with the support who's gonna help you as faster as possible ? In my opinion ORACLE is the best of because it's faster than MySQL you can administrate it and programming for any kind of troubles Even Though you need a wide space you can set how much you´re gonna use, different than Mysql and the most important thing the support is 24x7 mySQL also have a 24/7 support but all of the people here is talking about the free database. What you pay in mySQL is the support. The developers and a lot of third parties can give you the support that you need on any time that you want. Just pay them or in case for mySQL main site, subscribe to the support features that they have. They also install the software for you as part of the support. Unlike in ORACLE, support in mySQL is optional. Thay makes the software free. ORACLE needs a faster and bigger pc unlike a mySQL minimal system requirements. The thing that makes mySQL popular is the portability it offers. It is also known that even if you have a super fast database server but you load it with a bad database design.. the server can literally crawl..
Reply
zjsz007
May 28 2005, 09:35 PM
QUOTE(pedro @ Mar 22 2005, 12:16 PM) te best database for my is sql server yukon for you? Reply
solanky
May 29 2005, 02:58 AM
I have never worked on MySQL but by reading the post of members it seems that it is really a worth to try it. I have learned Oracle in my Masters in Computers but I feel that Oracle is not much user friendly. Now I am working on MS SQL Server and I like working on it. It is very easy to use and the in built help is very good like any other Microsoft products. I like the StoredProcedures and User Functions in it. These two helps me a lot in solving a lot of difficult queries. So SQL Server is best for me but I will give a try to MySQL soon.
Reply
Recent Queries:--
how the best find error in database - 84.93 hr back. (1)
-
best dbms for developing websites - 169.24 hr back. (1)
-
best database for intranet - 278.69 hr back. (1)
Similar Topics
Keywords : database, databases
- Free Or Opensource Database/schema Browser?
Alternatives to TOAD or PL/SQL Developer (6)
How To Understand A Database Schema
A very nice and simple tutorial (4) Yesterday while i'm seaching for a data model and database schema at the Library of Free Data
Models for a new project of a friend of mine i found there this nice and simple tutorial on How to
Understand a Database Schema . As its name says, this tutorial will help you to better understand a
Database Schema and covers the following basics topics that every Database Schema must define:
QUOTE Primary and Foreign Keys. One-to-Many and Many-to-Many Relationships. Inheritance.
"Rabbit's Ears", (Recursive relationships). The Scope of this tutorial is ....
Best Database
(13) What is the best free database if some one trying built a social networking website? And how to
operate it with dreamweaver 8?....
Some Useful Database Links.
(7) I thought I would take a moment to point the users here to some of the database resources available
for reference and learning. First I will start with actually designing the database. This site by
R937 covers the basics of database design. The author is professional database guru and a frequent
helper at the at DB forums listed below. The Library of Free Data Models is an excellent
resource for finding data models for projects you may have or as examples of well put together data
models. With around 500 data models the chances are you find something at least cl....
Database Access On Remote Server W/jsp
(0) Hello: I am new to JAVA and server-side applications and have a dumb question. I have set up
Tomcat on my machine and created a JSP program to query an Access database using a DSN-Less
connection. If I publish the page to a webserver and include the .MDB file will it work? I'm
not sure exactly what needs to be packaged with my Java application to make it work. Since I
don't have a remote server that supports .jsp I cannot really test it. I'm assuming that
JDBC driver would be bundled with my site but not sure. Thanks!....
Space Needed For Database
(10) Iam assuming the information in the databases i will create will be stored in the 500 MB space i
get, but since 500MB isn't enough iam wondering if you guys can tell me how much bytes the
following take: Varchar(x),Tinyint,Text,date,smallint,mediumint,bigint,float.... And the rest
present when you add/edit a row in a table. Also what are the ranges of tinyint,smallint,mediumint
and big int....
Mysql Database Entry By Excel Sheets
(2) Hello .. I would like to ask if i can use use Microsoft excel files in order to make entries to
mysql database. Thanks....
Mysql Database Management
(1) Hi i am new, I have a problem in understanding the query decomposition in D-DB. Can anyone help me
to understand the first question of the exercise 25.21 of Elmasri-Navath 4th edition? Consider the
following relations: BOOKS (Book#, Primary_author, Topic, Total_stock, $price) BOOKSTORE (Store#,
City, State, Zip, Inventory_value) STOCK (Store#, Book#, Qty) Consider a distributed database for a
bookstore chain called National Books with 3 sites called EAST, MIDDLE, and WEST. Consider that
BOOKS are fragmented by $price amounts into: B1:BOOK1:up to $20. B2:BOOK2:from ....
Accessing Ms Access Database From A Centralized Location?
(5) Hi I am a manager at a trading/wholesaling company (and have no programming background). I
customized the Northwind sample access database to make invoices and keep accounts for my company.
We now opening another office at a distant location. So, the order entry will be done at two
points(we plan to use the same Access database). I am not able to figure out how to access the same
MS Access database from two different location(as LAN can't be used). Moreover, we can't
afford to pay huge sums to the software developers. Can intranet or uploading the database t....
Integrate Access Database Onto Intranet Site
Looking to integrate access database into my intranet site (5) Hey guys, im new here and am looking for answers /tongue.gif" style="vertical-align:middle"
emoid=":P" border="0" alt="tongue.gif" /> Firstly, i have designed a database using M$ access, it
consists of multiple forms which i plan to host on an intranet website, i need to be able to add
records directly from the form on the intranet website aswell as being able to edit/review current
entries on forms in the database. My question is, how would i go about integrating these forms onto
the intranet website? i plan on keeping the database and the intranet site on the same d....
Database
prblem with it (1) i have free script but it is working fine on a lot of sites i tried to use it to my web site ....i
edit its config.php right and but my database name and my user name and password every thing right
and when i try to install it it gives me this error can`t connect to database please choose file
from this mobile.sql can any body help plz coz i tried huderd of times and no thing happend....
Connecting To A Remote Database
(9) I wondered if anyone here can help. I have a database on a remote server (A). I want to access it
through a php script on a different server C. I have allowed access on (A) in Cpanel - mysql dbases
- Remote Access by putting the IP address of server C The host of server (A) has also whitelisted
the IP of server C. Though I am having trouble connecting from server C which is with a different
webhost. any ideas how to get round this? I have though of SSH forwarding, but I think this can
only be used to connect a client - e.g. my pc to the remote server A. I do not ha....
Databases
(2) How do you access databases?Even though i don't have a hosting account yet i want to think
ahead. Please help thx, romeo123....
Free Graphical Tools For Databases
(7) There are a lot of different free software in Internet, but I have found only couple of free
graphical tools for database adminiatration. On another hand, MySQL is free for non commercial
usage. That's way it will be nice to have any good free GUI for this database. I remember the
time, when one of MySQL-Front versions was for free, but now it is opened only for testing period.
There is also free version of Toad, which is not full Toad, but it looks also very well - However, I
am not going to use Oracle (wchich is quite expensive commercial tool) on my desktop. The....
Need Help In Database Auto_increment
(9) i am creating a game and i set when someone registers than he gets id...in "extra" i have set it to
be "auto_increment" but whenever new player signs up he gets number bigger than 210...(my first id
was 211,next was 212,third was 213,fourth got 214) how to set it to go from 1 to infinite? thnx....
My Sql Database Help?
(3) Ok, i am new at web design, i dont know too much about it... I was working on a website for about
a month this is what i got, My Web , like i said, i dont know much.. i used FrontPage and did all
of that, my current host is AFMU which uses MySQL, but the way it is set up I dont know how to
acquire the URL of the database or any information i dont know what it means at all.. i just want to
do a simple login feature, i mean this is my first website and i am learning so I think it would be
a great feature to add in and learn. i can create data bases from there but do n....
Database Size?
So how big is everybody's MySQL database? (10) Well I know that MySQL databases can get rather big, so I was just wondering how big everybodies
databases were? Do you have really big ones, or are they relatively small? Also what do you store in
them? (just text, or binary data as well)....
All About Databases
Info, for you! (3) QUOTE Hi, I noticed there were a lot of questions in all of the database topics, so i went
around the internet using different sources, and have some information that will answer your
questions and help you understand databases. I hope this helps, and if you have any other questions
which arent answered below, please send a message asking. Thankyou. In computing, a database can be
defined as a structured collection of records or data that is stored in a computer so that a program
can consult it to answer queries. The records retrieved in answer to queries become i....
Examining Databases At A Whole Glance
SQL-92 specification (7) Most of us using databases or doing data minings are not aware of SQL-92 specification seemingly
these days. SQL-92 specifiaction is the SQL database query language standard. Oracle,mysql
postgresql,mssql and DB2 - most widely recognized SQL database programs - are all closely related to
SQL-92 specification for the use of query nevertheless how they implemented SQL-92 specification
features inside in the program. Implementation of SQL-92 specification features are applied in the
order of Oracle, postgresql and mysql. These databases might have specific database query....
How Many Concurrent Users For Oracle Database?
This is to analyse and get perfect result for How many concurrent use (1) Hi friends, How many concurrent users can practically access the oracle database?
they say tht the figure is hundreds of thousands users...is there any exact figure? or does the
number of concurrent users depend on any other factors as wel? I think depend on parameter
1.session 2.processes session Specific connection of a user to an Oracle instance through a user
process. A session lasts from the time the user connects until the time the user disconnects or
exits the database application. Multiple sessions can be created and exist concurrently for ....
Database Programming In Vba 6.0
(1) hi , i need some sample program in database.thanks....
Permission Problem With Mysql Database Creation
Please Help! (8) I seem to have a problem with accessing my database with proper permissions. I have set the my
database correctly giving my db username all priviliges yet i seem to be unable to even log on with
this username with a denied access error. Any ideas on resolving this?....
Is It A Good Practice To Store Image Or Other Binary Files Directly In A Mysql Database
(4) Hello to all of you beautifull people out there, I am new to MySQL, i just wanted to know if its a
good practice to directly store images and other binary files in a MySQL database. Any one with
help? Thanks....
Copy Databases In phpMyAdmin
(5) i have just got hosting here on astahost and i have to copy my databases from my old server... is
there an easy way of doing this? in phpmyadmin? thanx in advance you know lol /wink.gif"
style="vertical-align:middle" emoid=";)" border="0" alt="wink.gif" /> ....
MySQL Output Database Question
(18) I am new to MySql and have just created a database after using a script. My problem is not the
script, but what it says about putting it into the output file. I cant figure out the right terms
to put it in, I keep getting errors. I try using; SELECT*FROM 'database name' WHERE
'location' but it isnt working. I'm lost with this stuff, I really am. Can someone
please help me out?....
The Best Database
What do you think is the best database? (48) Ive been planning to create a online application which requires tons of stuff from database. Ive
been using interbase, at first it was good but after a month i find it not user friendly at all...
Its to hard to code in php.. Can any of you guys give me a good database which is easy to use?....
Mirror My MySQL Database To Another Mysql Server
(4) Hi..I want to ask if its possible to automatically mirror my mysql databases into another mysql
server?or create a small php script to do this? The reason is because, we all know that database is
very improtant if we have dynamic website. I have my forum hosted and i want to automatically
mirror this or backup into another mysql server(free). Like in freesql.org. So that im not afraid
that i forgot to backup my database..also i have one central backup database. Thanks for the
help..Im looking forward for this posibility.....
Need Advice On Creating Online Music Database
ps - dont know anything about databases! (6) I need to create a database of around 1000 music albums that I can put on my site, with the ability
to search the database according to several different criteria. Being a complete and total NOOB to
the world of databases, can anyone point me in the direction of some software that will let me
create a good-looking and functional database, but that isn't too complicated for me to use?!
Sounds like a tall order I know, be grateful if anyone can help though. Thanks! Topic edited to
reflect content better. ....
Embedded Database
Embedded Data base at client side, (7) Hi, Now its the era of Embedded databases, no more db servers, no more host,Because with embedded
db you can get all those options, what you are used to get with DB Servers. Some of Embedded DB Are
1) Cloudscape From IBM (NOW Derby from ASF) 2) HSQLDB (OpenSource) and many more Feel the power of
EDB Cheers Arunkumar.H.G....
phpBB Database Transfer
Anyone here knows how to? (10) Hello, i'm a newbie in using phpBB and I still lack knowledge in mySQL database. How do I
transfer the datas(users,configs, all of them) contained in my current forum to another one in
phpBB? I hope someone can help, a short but detailed tutorial would be good. Example is, if I want
to move to a new host and I want to transfer all the accounts on my old forum to the new one. Thanks
in advance, hope anyone here knows how to.....
Looking for database, databases
|
*SIMILAR VIDEOS*
Searching Video's for database, databases
|
advertisement
|
|
