1 reply to this topic

[Booj]

As I write this, i'm looking around at the WYSIWYG editor which is provided for ease of wrting my post (e.g bold underline, all done very simply) and this is exactly what i'm posting about. I have been programming for around 2 years now, and have general knowledge of almost all web languages, deep knowledge of PHP programming and others.

I've come to this huge decision where I need to choose my language of choice for a project i'm about to undertake.

I'm looking to create a service which uses a WYSIWYG editor (web based) and post the info somewhere to be drawn again somewhere else. Just like this forum, we get the text editor, save our test, and it is selected from the database when someone wants to view it.

So heres the "why this" and "why that" of the situation:

I am more familiar with PHP, and MySQL and feel very confident in using it for such a project, although putting 1 and 1 together, the logical language for my WYSIWYG editor is Javascript if I got down this path... A language im not too familiar with, and hate to debug it.

If I go with ASP.NET, I have already purchased source code of an ASP.NET C# WYSIWYG editor (www.freetexteditor.com), so that beats the Javascript problem, but then comes the C# problem similar to the Javascript problem. Another issue here is that i'm very new to ASP.NET and don't understand all fundamentals yet.

Now comes the selection of Database.

I definately want to try and stay away from MySQL - I love the Database, but I plan on having ALOT of data, and it will need to be managed quickly, promptly, and handled very well. I don't want to create my service with MySQL and then have all sorts of problems Migrating. I would love to start with MS SQL - but doing this with PHP seems to be on a very advanced level.

I know ASP.NET is built perfectly for MS SQL databases, now comes the problem of ADO.NET. It seems for me to talk to MS SQL I need to learn ADO.NET (why?). The problem I see appearing if I go with ASP.NET, ADO.NET, MS SQL, C# is the fact I have to learn 4 new subjects, and since its not exactly the simplest of applications I want to create - learning all of this makes it seem I won't be done with my project until next year.

The upsides of going with ASP.NET is the fact I can use VB.NET with it, which I know much about.

One extra question which has been boggling my mind is.

ASP.NET provides a service which allows you to register, login etc. All of this is done for you so easily, unlike PHP where you would make the database, the table, the rows, the code, the form. ASP.NET does it all, is it best method to use this sytem, or am I best to create my own? I do want to add my own attributes to users and be able to store other data for them, rather than simple permissions, and profiles.

Any help would be great.

Thanks, Adam

[rc69]

The only web-based WYSIWYG editors i've seen revolve around JavaScript regardless. From there, you're best bet would be to stick to the language you are strongest with, php.

I don't see why sticking with MySQL is such a bad idea. I've seen it handle large amounts of data quite easily.