Ok. due to the fact that it is a pain to be running many blogs all over the place, i have decided to move my software blog to my
main site. So, from now on, check out my
main site for posts.
Why am i trying to move my main blog to .TEXT? Well, simplet. programmability. plus, i can play with it since its written in C# and see if i can break or make better .TEXT. just for the laff. watch this space, or
my other blog for more.
If this works, it means nothing really, but i have managed to build a .TEXT blog posting app. could be handy if i move my
main blog to .TEXT, which i am thinking about... Ok. the last test failed because i had the text boxes mixed up and the content went into the title, and vice versa. anyway, hopefully this works...
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?