Geekzone: technology news, blogs, forums
Guest
Welcome Guest.
You haven't logged in yet. If you don't have an account you can register now.



19 posts

Geek
+1 received by user: 2

Subscriber

Topic # 112158 28-Nov-2012 11:09 Send private message

Over the past year I've been working on a website for my school as part of my scholarship portfolio. The website was a success, and will save my school around $300 in fees by not using a third-party solution. Now that it's done, I want to turn it into a proper product so that other schools can use it. I've gotten permission from the school to do this.

I signed up to BizSpark, and they accepted my application. I feel that hosting the website on Azure is a no-brainer, I mean free scalable cloud hosting, I'd be nuts to turn that down. However the database is what I'm pondering.

The website revolves around a MySQL database, however even though Azure offers MySQL should I consider switching to a SQL Server database? I feel that Microsoft giving me free access to these services, I'm obliged to use their products.

No matter which path I chose I'll have to restructure the database. I was in a rush designing it (three days before going live, school told me something they forgot and had to do a rewrite) and there are a lot of things I want to improve (foreign keys, remove the comma-delimited fields, etc.).

But should I stick with MySQL, which I know well and have used before, or move over to SQL Server for the sake of hosting the website on Azure?

Website stats:
  • Written in ColdFusion (requirement by the school) but porting the code to PHP
  • MySQL database
  • Only two rival products in New Zealand that are competing with me.
Almost forgot to say, it's a parent teacher interview booking website. You register, enter your children, site tells you who their teachers are, you book a time slot, website generates a PDF timetable for you and off you go.

Create new topic
1652 posts

Uber Geek
+1 received by user: 91

Trusted

  Reply # 724067 28-Nov-2012 11:16 Send private message

if you dont have a lot of time, then i would say no.

if you have some time, and want to learn another DB (SQL Server is my personal favourite db) then sure why not.

also you might want to checkout asp.net instead of php. if you love php and want to stick with it then cool, but asp.net has the best IDE around (visual studio, there is a free express version which should do all the things you need) and microsoft is really behind it, so always getting new stuff to play with (asp.net mvc4, webapi, razor all good things).

since you're developing with azure, asp.net might make your life easier.

BDFL
49205 posts

Uber Geek
+1 received by user: 4178

Administrator
Trusted
Geekzone
Subscriber

  Reply # 724073 28-Nov-2012 11:22 Send private message

Just because you are given the stack it doesn't you have to use all the products.

Are you planning to run this as a service to schools? Is the SQL license free forever or only for development/testing (MSDN style) or evaluation (Technet style)? If you have to later buy or rent MS SQL then it will cost more for your product to come out.

If you are not doing it as a service then are schools prepared to pay for SQL licenses (which aren't cheap)?

Perhaps in this scheme better use the compute power and go for the free database instead?






19 posts

Geek
+1 received by user: 2

Subscriber

  Reply # 724100 28-Nov-2012 11:47 Send private message

also you might want to checkout asp.net instead of php. if you love php and want to stick with it then cool, but asp.net has the best IDE around (visual studio, there is a free express version which should do all the things you need) and microsoft is really behind it, so always getting new stuff to play with (asp.net mvc4, webapi, razor all good things).


Main problem is that I develop on a Mac, and my HDD isn't big enough to dual boot Windows. I did have a look at ASP.NET and more specifically Razor, but I have absolutely no experience using it. I've used PHP for a couple of years so I feel more comfortable using it.  I'd rather build a website using a language where I know my way around.

Are you planning to run this as a service to schools? Is the SQL license free forever or only for development/testing (MSDN style) or evaluation (Technet style)? If you have to later buy or rent MS SQL then it will cost more for your product to come out. 


The website is a subscription based service. School pays a yearly fee for unlimited interview sessions and with full access to features. With BizSpark an Azure-hosted SQL Server database, you've got a three year license to use the software but after that you've got to pay a discounted fee for continuing to use their services. So there is always that risk of having to move off Azure and start paying for a SQL Server license (which I had a heart attack when i looked at the pricing)

After reading over the replies, maybe it might just be easier to use MySQL. That way if I have to move off Azure I don't have to worry about SQL Server licensing.

1761 posts

Uber Geek
+1 received by user: 183


  Reply # 724104 28-Nov-2012 11:52 Send private message

possum888:
also you might want to checkout asp.net instead of php. if you love php and want to stick with it then cool, but asp.net has the best IDE around (visual studio, there is a free express version which should do all the things you need) and microsoft is really behind it, so always getting new stuff to play with (asp.net mvc4, webapi, razor all good things).


Main problem is that I develop on a Mac, and my HDD isn't big enough to dual boot Windows. I did have a look at ASP.NET and more specifically Razor, but I have absolutely no experience using it. I've used PHP for a couple of years so I feel more comfortable using it.  I'd rather build a website using a language where I know my way around.


In that case, at least look at ruby on rails or something, after reading this:

http://me.veekun.com/blog/2012/04/09/php-a-fractal-of-bad-design/

(I'm half tongue-in-check, half serious.  At the very least it's a good read for a laugh)



19 posts

Geek
+1 received by user: 2

Subscriber

  Reply # 724112 28-Nov-2012 11:58 Send private message


In that case, at least look at ruby on rails or something, after reading this:
http://me.veekun.com/blog/2012/04/09/php-a-fractal-of-bad-design/

(I'm half tongue-in-check, half serious.  At the very least it's a good read for a laugh)


Trust me I've read that before. Wink Again I'd rather stick with PHP simply for the fact that I don't have to learn a whole new language.

1761 posts

Uber Geek
+1 received by user: 183


  Reply # 724124 28-Nov-2012 12:06 Send private message

possum888:
Trust me I've read that before. Wink Again I'd rather stick with PHP simply for the fact that I don't have to learn a whole new language.


Fair enough; there are plenty of great sites built on PHP, but I can never resist pointing PHP devs to that - every time I end up looking at PHP code it makes me cringe :P

TBH returning to your original question around MySQL vs SQL Server I'd apply similar reasoning: If MySQL does what you need and you're familar with it then stick with it.

Create new topic




Twitter »
Follow us to receive Twitter updates when new discussions are posted in our forums:



Follow us to receive Twitter updates when news items and blogs are posted in our frontpage:



Follow us to receive Twitter updates when tech item prices are listed in our price comparison site:




News »

Trending now »
Hot discussions in our forums right now:

Lightbox press event release
Created by freitasm, last reply by steve98 on 2-Aug-2014 10:25 (136 replies)
Pages... 8 9 10


New Mobile plans coming?
Created by nunasdream, last reply by Quibbler on 1-Aug-2014 19:57 (108 replies)
Pages... 6 7 8


Are IT staff supposed to know everything
Created by BTR, last reply by Dingbatt on 2-Aug-2014 08:42 (41 replies)
Pages... 2 3


2010 Honda Jazz, Suzuki Swift - which has higher maintenance cost?
Created by joker97, last reply by jonathan18 on 31-Jul-2014 10:47 (76 replies)
Pages... 4 5 6


Hierarchy of a mistake: Gerry Brownlee
Created by joker97, last reply by DonGould on 29-Jul-2014 21:57 (93 replies)
Pages... 5 6 7


Does acupuncture work?
Created by timmmay, last reply by timmmay on 1-Aug-2014 19:22 (52 replies)
Pages... 2 3 4


"keyless" keys - questions
Created by joker97, last reply by MadEngineer on 30-Jul-2014 22:02 (35 replies)
Pages... 2 3


Dick Smith in Continual Sale Mode
Created by Dynamic, last reply by mattwnz on 1-Aug-2014 21:31 (95 replies)
Pages... 5 6 7



Geekzone Live »
Try automatic live updates from Geekzone directly in your browser, without refreshing the page, with Geekzone Live now.

Are you subscribed to our RSS feed? You can download the latest headlines and summaries from our stories directly to your computer or smartphone by using a feed reader.

Alternatively, you can receive a daily email with Geekzone updates.