Waspman
Posts: 948
|
| Posted: 02/22/2007, 1:21 AM |
|
What's best?
.Net - MSsql
.Net - MySQL
or should I go PHP - Mysql
The project will be massive so cost will be an issue.
Many thanks
_________________
http://www.waspmedia.co.uk |
 |
 |
jres
|
| Posted: 02/22/2007, 1:32 AM |
|
It depends from your customers.
.NET + MsSql much faster than PHP + MySql
.NET + MySql - it works not bad but - why?
Of course, the final decision depends from specific situation.
|
|
|
|
Waspman
Posts: 948
|
| Posted: 02/22/2007, 3:16 AM |
|
Thanks jres,
Well I'm the customer so I was just asking the question before I start.
Want to make sure I set off on the right foot. Had a close encounter with Joomla and thought maybe there was something in the MySql/PHP approach if all these people are getting excited about it ( )
The app could be very big would this impact on the cost?
_________________
http://www.waspmedia.co.uk |
|
|
|
wkempees
|
| Posted: 02/22/2007, 11:12 AM |
|
Waspman,
PhP/MySQL (with or without CCS) powerful, free, proven, widley available
resources.
Hosting: 90%+ of all hosting schemes provide PhP MySQL in various versions
and flavours.
If more rigid DB needed PhP Postgress is an option too.
..Net/MSSql
Hosting will need MS Platform (although Lx/Mono could be option)
In my country less well available and only at higher cost.
Tooling and libraries no experience but if the CCS Forum is anything to go
by.......
Good luck on your decisionmaking.
If you are the customer do a test project by filtering out the most dificult
functionality first.
Walter
|
|
|
|
Waspman
Posts: 948
|
| Posted: 02/23/2007, 2:11 AM |
|
Looks like it's gona be PHP/MySQL -
MSsql's is still not playing nice and Navicat makes MySQL Sooooooooo easy!
Just wondering about AJAX and PHP?
_________________
http://www.waspmedia.co.uk |
|
|
|
wkempees
|
| Posted: 02/23/2007, 2:53 AM |
|
Navicat rules!
Purchased Enterprise version just a few days ago.
Dumped MySQLFront 3x as they dumped themselves, tried HeidiSQL but they need
to mature.
MySQL's own toolkit is good but Navicat is so easy and intuitve.
What about AJAX and PhP?
Works ok, depending of course on the technique/libraries you choose and the
way you might want to implement it in CCS.
Benjamin K has many good advices available, as have the various communities,
see no problems there.
Happy Devving
Walter
|
|
|
|
Waspman
Posts: 948
|
| Posted: 02/23/2007, 3:15 AM |
|
Just done a quick test in PHP.
Everything went perfect - no connection problems ran first time.
I've been worrying about MS SQL for over a year and MySQL(and Navicat) disspelled all my fears in minutes!
Now I just got to get my head round PHP
Tony
_________________
http://www.waspmedia.co.uk |
|
|
|
wkempees
Posts: 1679
|
| Posted: 02/23/2007, 3:17 AM |
|
T,
Shoot when needed.
W.
_________________
Origin: NL, T:GMT+1 (Forumtime +9)
CCS3/4.01.006 PhP, MySQL .Net/InMotion(Vista/XP, XAMPP)
if you liked this info PAYPAL me: http://donate.consultair.eu
|
|
|
|
Waspman
Posts: 948
|
| Posted: 02/23/2007, 4:48 AM |
|
Thanks man.
_________________
http://www.waspmedia.co.uk |
|
|
|
Benjamin Krajmalnik
|
| Posted: 02/24/2007, 7:32 PM |
|
Me, Good advice? <vbg>
For the fun of it, I will throw a wrench into your plans, Waspman.
I really do not know what your requirements are, but for my massive
application I am using PostgreSQL.
First of all, it's much more feature rich then MySQL.
Second of all, the support on the lists is excellent.
Third, it is truely free (MySQL costs about $500/server last time I checked
unless your application is Open Source).
Before deciding on a database for our application (over 10 million
insert/update queries per day) I considerd everything. The applicatio was
initially running under MS SQL Server 2000, but th performance under
PostgreSQL is by far better - nte to mention some of the features which have
made development a breeze.
Now, as for Ajax, I need to understand what you mean by Ajax, since two
different thing come to mind - Rich UI or what Ajax really is - a request to
the database which runs via XMLHTTP.
For the latter, I have been using xAjax and have been quite pleased with it.
I use it extensively to set session values in the background to avoid
passing parameters via the URL. For a rich interface, you could use any of
the many available libraries (although they are quite heavy), or use
independent scripts, which is what I have done.
There are some very good scripts in www.dhtmlgoodies.com. If you have more
specific questions, I'll be happy to try and point you in the right
direction.
On the database side, I have become a PostgreSQL evangelist. It took a bit
of playing aound to fine tune it, but I hav found its performance to be
second to none at any price. I am running a dedicated database server and a
separate server as a web front end. Both servers are running FreeBSD 6.1.
The webserver is running Apache 2.2, PHP 5.2.1, eAccelerator. Currently I
am running PostgreSQL 8.1.x, although I will be moving to 8.2 next time I
have scheduled down time due to even higher performance and some new
features.
HTH
|
|
|
|
Waspman
Posts: 948
|
| Posted: 02/25/2007, 2:54 AM |
|
Yeah that is definitely a wrench (or spanner as we say in the UK)
I've decided to go PHP-MYSQL cos of the speed and easy of development.
I need to get this working quick, like this week. I've already done the prototype.
So the question is, lets say it gets something like 25K hits a day within six months, if it increases to the sort of numbers you are used to, can I upgrade?- Still keep the PHP and just upgrade the db?
Thanks
Tony
_________________
http://www.waspmedia.co.uk |
|
|
|
wkempees
|
| Posted: 02/25/2007, 6:21 AM |
|
Tony,
As to the cost involved with MySQL afaik there is non for the Community
version.
Upgrade the DB meaning from MySQL to Postgress should be easy as long as you
know what to do and have the multi CCS (!).
Postgress is more feature rich than MySQL so it will understand the SQL
without a glitch.
I for one run a large application based on PhP/MySQL, where multi
company/multi-user are operating on a single DB.
Use is comparable with ledger-functionality so many transaction per day.
We have no performance problems on this platform, although from past
experience I do subcribe to Benjamins Postgress message.
Walter
"Waspman" <Waspman@forum.codecharge> schreef in bericht
news:245e16adaade33@news.codecharge.com...
> Yeah that is definitely a wrench (or spanner as we say in the UK)
>
> I've decided to go PHP-MYSQL cos of the speed and easy of development.
>
> I need to get this working quick, like this week. I've already done the
> prototype.
>
> So the question is, lets say it gets something like 25K hits a day within
> six
> months, if it increases to the sort of numbers you are used to, can I
> upgrade?-
> Still keep the PHP and just upgrade the db?
>
> Thanks
>
>
> Tony
>
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
Benjamin Krajmalnik
|
| Posted: 02/25/2007, 1:14 PM |
|
Walter,
As far as I know, if your software is not Open Source, there is a cost
involved.
Granted, the majority of prople probably do not abide by that, but
nevertheless that is the license.
Now, if all you are going to be getting is 25K hits per day, that is
nothing. In my case, I am pumpimg millions of record inserts per day via an
infrastructure monitoring platform.
The UI for the end user is PHP, and with PostgreSQL it is blazingly fast.
In my case, the richness of data structures enabled me to write code which
would have been a bit awkward with MySQL or MS SQL.
Now, my biggest concern with MySQL is that they do not own their own
transactional database engine - at leaset not yet. Both BDB and InnoDB are
licensed, and I believe both of them are now owned by Oracle, which makes me
wonder.
I have found PostgreSQL to be second to none, at least with our
rwequirements (which may be more stringent than most people's).
The important hing, regardless of which database you use, is to only have
one db engine running on a specific machine. If you host with soimeone who
offers both MySQL and PostgreSQL, make sure the physical device which you
are running is only configured to run one of them - otherwise you will be
hit by performance issues with disk contentions.
Regards,
Benjamin
|
|
|
|
gbolz
Posts: 13
|
| Posted: 03/17/2007, 3:08 AM |
|
Benjamin,
is PostgreSQL compatible to MySQL or have I to change the php Code?
Thank you for your answer.
Gerhard
|
|
|
|
mamboBROWN
Posts: 1713
|
| Posted: 03/17/2007, 5:22 PM |
|
Benjamin Krajmalnik
I am interested in how you came up with the notion that there is a cost associated with MySQL. Based on my understanding and long use of MySQL I have to agree with wkempees. Benjamin please provide evidence of your statements (from MySQL). We do not want to mislead anyone about MySQL.
|
|
|
|
peterr
Posts: 5971
|
| Posted: 03/17/2007, 11:41 PM |
|
Hi,
It is also my understanding that MySQL has associated costs, but only if you are planning to distribute/include it with commercial software:
http://www.mysql.com/company/legal/licensing/
Quote MYSQL licensing:If you are developing and distributing open source applications under the GPL License, then you are free to use MySQL under the GPL License.
For OEMs, ISVs, and VARs who distribute MySQL with their products, and do not license and distribute their source code under the GPL, MySQL provides a flexible OEM Commercial License.
However, when you install MySQL yourself or your customer installs it separately from any other products, then the GPL-chain ends there and MySQL is used as a standalone GPL product and doesn't force GPL licensing onto your Web application. Therefore you can install and use MySQL by itself as a GPL product, then use it however and with whatever you like.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
mamboBROWN
Posts: 1713
|
| Posted: 03/18/2007, 11:32 AM |
|
peterr,
I agree with your information/statement. Where I had a problem is when Benjamin Krajmalnik stated that Quote :Third, it is truely free (MySQL costs about $500/server last time I checked
unless your application is Open Source).
Which gives the impression that there is a cost associated with MySQL unless your application is Open Source. This is not a true statement.
|
|
|
|
|
