1

C++ SQLite Example with Parameterized Query

on in C++ SQLite

You might know the benefits of using parameterized query (e.g boost query performance in term of speed, avoid SQL injection attack, etc) but how it can be done in programming way might sound like a different story to you. 🙂 In this tutorial, I’m going to show you how we can achieve that in using......

[ Click to Continue ]
0

C++ SQLite Example with Atomic Transaction

on in C++ SQLite

Wonder how you can implement an automic transaction in SQLite so that your queries will either completely occurs, or completely fails to occur? In this tutorial, i will demonstrate how you can do that in your C++ code by modifying my previous C++ Sqlite example. My previous C++ Sqlite tutorials can be found at the......

[ Click to Continue ]
9

Compiling and Installing OpenSSL for 32 bit Windows

on in OpenSSL Windows

What is OpenSSL? @Wikipedia: “OpenSSL is an open-source implementation of the SSL and TLS protocols. The core library, written in the C programming language, implements the basic cryptographic functions and provides various utility functions.” Enough for the explanation of OpenSSL. 🙂 Let’s go for the real tutorial on how you can install OpenSSL into you......

[ Click to Continue ]
0

Using Transcation in C++ PostgreSQL Example

on in C++ PostgreSQL

There are times when you need to execute a series of SQL statements in order to achieve data consistency. For example, a customer is going to transfer his money from bank account to settle a bill payment. We will need to update both customer bank account and payee account accordingly. Failure to update either custormer......

[ Click to Continue ]
7

C++ PostgreSQL Example in Linux

on in C++ G++ Linux PostgreSQL

In this tutorial, i’ll demonstrate an example on how to connect to PostgreSQL database using gcc in linux. Also, i’ll demonstrate some basic SQL execution in the C++ example so that it give better understading to you how all of these are working. If you are looking a tutorial for windows platform, you could visit......

[ Click to Continue ]
0

Get total seconds in C#

on in .net c#

Sometimes you might want to knon how much time will it take to execute a certain process in C#. Here is a simple example to demonstrate how you can achieve this by using the TimeSpan attribute. 12345678910111213// clock the start time DateTime start_time = DateTime.Now; // To-do: Add you process here. // clock the end......

[ Click to Continue ]
0

C++ SQLite Example in Linux

on in C++ G++ Linux SQLite Ubuntu

This example will demonstrate how you can write a C++ program to utilize SQLite as your program database file in Linux environment. I am using Ubuntu in this demonstration. If you are new to C++ & SQLite in Ubuntu, it is advisable that you read the following article so that you have better understanding what......

[ Click to Continue ]