thinking of a new app, but thinking problems are there...
Ok. I am thinking of a new blogging app, but i dont know what to do with it yet. it will be a desktop blogging application, and i dont know weather do use
SQL Server Express or XML. SQL Server Express has some major advantages over XML, but XML has its advantages too. So, the advantages of SQL Server are:
Speed: Very fast for queries
Managability: Single file with the DB in it.
Support: Fully supported by the .NET Framework, and its SQL too.
Ease of programming: Because its SQL, its a lot easer to program for, and it ties directly in with the .NET frame work and IDE.
Disadvantages:
Size: Ok. my app could be up to a meg is size, maybe a little more, but i have to get the .NET framework 2.0 and SQL Server Express to the users machine. I know the .NET 2.0 boot strapper could help, but its still a hefty download for the users, and if its only a 1 or 2mb file, some are just not going to download!
I cant think of any other disadvantages to SQL Express, but if you have any tell me!
when it comes to XML, the only advantage of XML is the size of it. Its basicly the oppisite to SQL Server Express. i know i can write and read XML with the Dataset, but i still have to do some code to find stuff i want in there, and theres no real Query Language for data sets. So, its really a toss up between size and speed (etc). What would you choose?