The definition in SQLite official site is the following: “SQLite is a software library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine. SQLite is the most widely deployed SQL database engine in the world.” So, how can we use SQLite engine to develop standalone desktop database application in Windows environments. At SQLite official [...]
I maintained a MySQL server and automatically dump everything on the server to a file. The dump process is achieved by a shell script. #!/bin/bash date=`date -I` mysqldump –add-drop-table -u xxxxx -pxxxxx usbargains | gzip > /samba/dat$ mysqldump –add-drop-table –all-databases -u xxxxx -pxxxxx | gzip > /samb$ To be aware that the username and password [...]
I’ve been dreaming of creating MS Access databases through VBScript for ASP server for a long time. But I did not know how to create AutoNumber field. I spent two nights at home to write this vbscrip because I got a bad cold and did not go to office. At the beginning, I tried to [...]
If you have a Twitter account, you will know there are friends follow you and you are not following them. To be nice to your fans, you’d better follow them back. If you have a large number fans added everyday, it will be hard to catch up. Now it is time to automate the process. [...]
The following example describes a way to process XML file, treating the XML file as text file. We all know that XML file is well structured and can be read and written by using specilized functions and classes. Sometime it is more convenient to treat the file as text file. Here is an simple example. [...]