Blog

Sometimes for testing purposes, you may want to use custom self-signed HTTPS SSL certificates. But C# client application is not willing to connect to the server with a self-signed certificate, throwing the error "Could not create SSL/TLS secure channel".

If you are writing an international website, it is better to show timestamps to the users in their local timezone. Not everybody can easily translate time from UTC to their local time. Displaying time in a different timezone is confusing to the users and can lead to many misunderstandings. That's why you may want to give the user a choice to select timezone and then make them happy by displaying all timestamps in their local timezones.

But how do you get the timezones list? Here is a little C# code example that shows how to display UTC offset and user-friendly timezone labels:

SQLite is a tiny database that is specifically designed for embedded use. It is a single-file database that is deployed side-by-side with your application. If you have to write an application that needs just a limited set of database functionality, then a tiny SQLite library has a big advantage over SQL Server of not having any dedicated installer. Basically SQLite is just a simple DLL file that is deployed with the executable of your application. It can be even compiled in your C/C++ application, as SQLLite is distributed in a form of single .c file (called "amalgamation"). Also, SQLite comes completely free of charge.

Having data secure is critical for the reliability of the applications. It is very important to have data consistent when managing user's finance, ensuring reliable control of industrial processes, ensuring stable work of medical equipment, etc. But the storage sometimes fails, the transmission lines fail, lastly, there are bugs in the software application. All those factors produce corruption to critical data.