I am a bit sorry that I took such a long break from blogging, but from now on new posts should appear here a little more regularly. It will not be like the old days when there was something new almost every day, but there should definitely be something new at least a few times a month. But back to my websites. They look exactly the same at first glance, but under the hood there is somewhat different code. Specifically, I made these changes:
- The website no longer runs on 2 separate SQLite databases; everything is now in 1 MSSQL DB. The downside is that I have only 200 MB of space on it, but on the other hand it is faster than SQLite and also handles high load better.
- Some things I now do not store in the DB because they are too large, but I have worked out a new system for them.
- Each website has its pages in its own folder (for example the Ggdag folder), which you can access quickly, for example via the address 👻 The server was sent to a retirement home for domains.. Besides that, there are also Shared pages, which have no pages of their own and contain only code used by several websites.
- Some pages that used to be only on BibleServer are now on www.sunamo.cz – a website with a summary of which websites and profiles I have. These are pages that concern several or all of my websites, such as 👻 This link is deader than Flash Player..
- A single registration once again works across all the websites, but everything is faster now, because when you want to log in to Ggdag, for example, the website no longer has to ask through a web service but asks the DB directly whether the login and password match.
- I made myself pages that helped me convert those DBs to SQL Server or that generate class files for me, which are then consistent. If I had to write them by hand, it would cost me more time than it takes to achieve the same result with this generator.
Of course, the biggest advantage is that the code is the same everywhere, so I know how each method works, which means I not only do not have to write it, I do not even have to debug and test it, and my naming is not a mess. - The website runs both at www.sunamo.cz and at www.sunamo.cz . The address www.sunamo.cz will probably disappear over time, though, so I recommend not using it.
- For me as a developer and coder it also brings more comfort and time savings, because I have everything in 1 place, everything is shared, I only have to upload everything once, and I only have to fix everything once (which is very important for me, given how easily distracted I am). You may be wondering why I am only coming out with this now and what I was doing all the time I was not posting on this blog – the answer is surprisingly simple – sleeping and slacking off.
Well, not only that. First I merged these websites into one, but each of them still had a separate DB. Then I told myself that it made no sense this way and started switching it to a SQL Server DB. It also took me some time to rewrite the class containing the methods that worked with the DB, tables, rows, columns and cells. Today this class has 1416 lines, although of course some of it is commented out and so on. - I have also written a program called HostingManager, which I will talk and write about in the next blog post. To briefly explain what the program does: at the press of a single button it first saves to the DB a list of files (including their hash and size) and folders, and then when I hit upload (only the specific websites I choose get uploaded – the program remembers the selection – or all of them, but I always use just the specific websites).
It then looks at the local files on my machine, compares them, uploads the changed ones, deletes the ones that no longer exist from the hosting too, and uploads the new ones. The next article should also include part of the source code of my HostingManager. - I will focus fully on web development, now that I have paid hosting. I thought I would also develop apps for Windows 8, but unfortunately I do not have much time left for that. Still, I already have 1 app for Windows 8 developed, but to get it out into the world I would have to buy a developer account for the Windows Store, which, when I last checked around October 26, cost almost 900 CZK, and on top of that I could not even pay for it with my MasterCard. Today I could, because I have a better Visa :D.
All that is left is to add the addresses of these 2 old-new websites of mine: 👻 The server went down, the owner moved out, and DNS forgot all about it. 👻 The server was sent to a retirement home for domains.🙂