Comments on the generic makefile show what changes are needed. If the configure script does not work out for you, there is a generic makefile named “Makefile.linux-gcc” in the top directory of the source tree that you can copy and edit to suit your needs. The configure script uses autoconf 2.61 and libtool. Make test # Run some tests (requires Tcl) Make sqlite3.c # Build the "amalgamation" source file sqlite/configure # Run the configure script Mkdir bld # Build will occur in a sibling directory Then run “make”.įor example: tar xzf # Unpack the source tree into "sqlite" Cd into the build directory and then from the build directory run the configure script found at the root of the source tree. It is recommended, but not required, that the build directory be separate from the source directory. Compilingįirst create a directory in which to place the build products. Or type “fossil ui” to get a web-based user interface. To install, simply download or build the single executable file and put that file someplace on your $PATH.) Then run commands like this: mkdir ~/sqliteĪfter setting up a repository using the steps above, you can always update to the lastest version using: fossil update trunk # latest trunk check-inįossil update release # latest official release (Source tarballs and precompiled binaries available here. If you do want to use Fossil to check out the source tree, first install Fossil version 2.0 or later. Or browse the timeline to locate the check-in desired, click on its information page link, then click on the “Tarball” or “ZIP Archive” links on the information page. Latest release as Tarball, ZIP-archive, or SQLite-archive.įor other check-ins, substitute an appropriate branch name or tag or hash prefix in place of “release” in the URLs of the previous bullet. Lastest trunk check-in as Tarball, ZIP-archive, or SQLite-archive. If you do not want to use Fossil, you can download tarballs or ZIP archives or SQLite archives as follows: If you pulled your SQLite source code from a secondary source and want to verify its integrity, there are hints on how to do that in the Verifying Code Authenticity section below. Always use the official name, not the Git-name, when communicating about an SQLite check-in. The official check-in name can also be seen in the manifest.uuid file in the root of the tree. The offical names for check-ins are found in a footer on the check-in comment for authorized mirrors. The names of check-ins and other artifacts in a Git mirror are different from the official names for those objects. If you are reading this on GitHub or some other Git repository or service, then you are looking at a mirror. The Fossil repository contains the urtext. SQLite sources are managed using the Fossil, a distributed version control system that was specifically designed and written to support SQLite development. If you are looking for the official SQLite source repository please visit Fossil. This repository is a fork of the SQLite Git mirror for the Chromium release branches of SQLite. Note: This is not the official SQLite repository. However, many other test scripts and most of the documentation are managed separately. repository contains the complete source code for the SQLite database engine. executeQuery ("SELECT * FROM urls where visit_count > 100") Statement = connection.createStatement () getConnection ("jdbc:sqlite:/home/username/.config/chromium/Default/History") Run: java -classpath ".:sqlite-jdbc-3.7.2.jar" GetChromiumHistory The program compiles and runs on my Linux 2.6.39 environment: /** You will need to change the argument for getConnection () to point to where the history files reside on your machine. The program was adapted from the java workspace website (as credited in the code). Since the original poster asked for a simple program, here it is. Return browser " - " title " - " url Public URL(string url, string title, string browser) String CommandText = "select * from " table ĭB = new SQLiteDataAdapter(CommandText, sql_con) Sql_cmd = new SQLiteCommand(CommandText, sql_con) ĭataTable ExtractFromTable(string table, string folder) String CommandText = "delete from " table Sql_con = new SQLiteConnection("Data Source=" dbPath Void DeleteFromTable(string table, string folder) If (tempstr != "Local")įor (int i = 0 i ExtractUserHistory(string folder)ĭataTable historyDT = ExtractFromTable("urls", folder) ĭataTable visitsDT = ExtractFromTable("visits", String tempstr = documentsFolder.Split('\\') ĭocumentsFolder = "\\Google\\Chrome\\User Data\\Default" String documentsFolder = Environment.GetFolderPath Net from here and add the references to. You probably also want to download the SQLite for. Most of the code I got from here but I tweaked it abit to add support for Google Chrome. Here is a class I created to read browsing data from Google chrome.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |