Difference between revisions of "SQLite: Instalasi menggunakan apt-get"

From OnnoWiki
Jump to navigation Jump to search
 
Line 27: Line 27:
 
  apt-get install sqlite3 libsqlite3-dev
 
  apt-get install sqlite3 libsqlite3-dev
 
  cp /usr/bin/sqlite3 /usr/local/bin/
 
  cp /usr/bin/sqlite3 /usr/local/bin/
 +
 +
 +
==Pranala Menarik==
 +
 +
===Secara Umum===
 +
 +
* [[Sistem Operasi]]
 +
 +
===Instalasi Linux===
 +
 +
* [[Linux: Skema Partisi di Linux]]
 +
* [[Linux: Instalasi Sistem Operasi]]
 +
* [[Linux: Membackup Harddisk Laptop ke USB harddisk]]
 +
 +
===Command Line Interface===
 +
 +
* [[Linux: CLI untuk Survival]]
 +
* [[Linux: Membuat Shell Script]]
 +
* [[Pengantar Pemrograman Bash Shell di Linux]]
 +
 +
====Repository & Penggunaannya====
 +
 +
* [[Repository]]
 +
* [[Membuat Repository Ubuntu Lokal menggunakan debmirror]]
 +
* [[Contoh isi file /etc/sources.list di Ubuntu]]
 +
* [[OS: Penggunaan apt-get]]
 +
 +
====Instalasi Aplikasi====
 +
 +
* [[SQLite]]
 +
* [[SQLite: Instalasi menggunakan apt-get]]
 +
* [[SQLite: Compile dari source]]
 +
* [[SQLite: Cara Cepat Menggunakan SQLite]]
 +
* [[SQLite: Command Line Shell]]
 +
 +
===Compile Kernel===
 +
 +
* [[Kernel]]
 +
* [[OS: Linux Kernel]]
 +
* [[Kernel: Anatomi Kernel Source]]
 +
* [[Compile Kernel]]
 +
* [[Compile Kernel: Konfigurasi Kernel]]
 +
 +
===Remaster Linux===
 +
 +
* [[Cara Cepat Melakukan Remastering Ubuntu]]
 +
* [[OS: Linux Buatan Indonesia]]
 +
 +
===Sistem Operasi untuk Embedded===
 +
 +
* [[OpenWRT]]
 +
* [[OpenWRT: Download Firmware yang sudah jadi]]
 +
* [[OpenWRT: Source Repository Download]]
 +
* [[OpenWRT: Melihat Daftar Package]]
 +
 +
====Membuat Firmware Sendiri====
 +
 +
* [[OpenWRT: Build Firmware]]
 +
* [[OpenWRT: Build Firmware Buffalo WZRHPG450H]]
 +
* [[OpenWRT: Build Firmware Buffalo WZRHPG300N]]
 +
* [[OpenWRT: Build Firmware Ubiquiti NanoStation2]]
 +
* [[OpenWRT: Build Firmware Mikrotik RB433]]
 +
* [[OpenWRT: Build Firmware Linksys WRT160NL]]
 +
* [[OpenWRT: Build Firmware Linksys WRT54GL]]
 +
 +
====Flash ke Device====
 +
 +
* [[OpenWRT: Flash Linksys WRT54GL]]
 +
* [[OpenWRT: Flash Buffalo WZRHP450H]]
 +
* [[OpenWRT: Flash Buffalo WZRHP300N]]
 +
 +
====Beberapa Tip====
 +
 +
* [[OpenWRT: Mikrotik RB433]]
 +
* [[OpenWRT: 3G modem]]
 +
* [[OpenWRT: Build Firmware dengan 3G Modem Support]]
 +
* [[OpenWRT: Setup Firewall]]
 +
* [[OpenWRT: Konfigurasi UBNT NanoStation2 tanpa WebGUI]]
 +
 +
===Tuning Kernel===
 +
 +
* [[OS: Parameter Kernel Default]]
 +
 +
====Tuning Kernel Scheduler====
 +
 +
* [[OS: Kernel Scheduler]]
 +
* [[OS: Tuning Kernel Scheduler]]
 +
* [[OS: Tuning Completely Fair scheduler CFS]]
 +
* [[OS: Complete Teori Tuning Kernel Scheduler]]
 +
 +
====Tuning I/O Scheduler====
 +
 +
* [[OS: Tuning Completely Fair Queueing CFQ I/O scheduler]]
 +
* [[OS: Complete Teori Tuning I/O Performance]]
 +
 +
====Tuning Manajemen Memory====
 +
 +
* [[OS: Tuning Manajemen Memory]]
 +
 +
===Android===
 +
 +
* [[Pemrograman Java]]
 +
* [[Pemrograman Android]]
 +
* [[Android: Aplikasi Menarik]]
 +
* [[Android: Download APK]]
 +
* [[Android]]
 +
* [[Pemrogramman Android]]
 +
* [[OS: Android - Mempersiapkan Development Environment]]
 +
* [[OS: Android - Memeriksa Spesifikasi Handphone yang digunakan]]
 +
* [[OS: Android - Membuat Mirror Source]]
 +
* [[OS: Android - Download]]
 +
* [[OS: Android - Download Source Untuk Device CyanogenMod]]
 +
* [[OS: Android - Membuat Folder untuk Bekerja]]
 +
* [[OS: Android - Mirror Source]]
 +
* [[OS: Android - Mirror Source AOKP]]
 +
* [[OS: Android - Mirror Source CyanogenMod]]
 +
* [[OS: Android - Build]]
 +
* [[OS: Android - Build CyanogenMod]]
 +
* [[OS: Android - Build AOSP]]
 +
* [[OS: Android - Build Untuk Motorola]]
 +
* [[OS: Android - Modifikasi build.prop]]
 +
* [[OS: Android - Porting Android]]
 +
* [[OS: Android - Membuka Lock]]
 +
* [[OS: Android - Android Studio]]
 +
* [[OS: Android - x86]]
 +
 +
===Membuat Kernel Module===
 +
 +
* [[OS: Mengerti System Call]]
 +
* [[OS: Membuat Kernel Modul]]
 +
* [[OS: Kernel Modul]]
 +
* http://www.tldp.org/LDP/lkmpg/2.6/html/index.html
 +
 +
===Monitoring & Benchmark===
 +
 +
* [[OS: Build in Monitoring Tool]]
 +
* [[Linux Benchmarking]]
 +
* [[OS: Benchmarking menggunakan UnixBench]]
 +
* [[OS: Benchmarking menggunakan LLCBench]]

Latest revision as of 13:56, 2 April 2014

jika sebelumnya pernah di instalasi sqlite3 ada baiknya lakukan

rm /usr/local/bin/sqlite3

Install sqlite3

apt-get install sqlite3 libsqlite3-dev

SQLite3 suka rewel, coba di test dulu

sqlite3 --version

Yang seharusnya keluar

3.7.15.2 2013-01-09 11:53:05 c0e09560d26f0a6456be9dd3447f5311eb4f238f

Kalau ada error, SQLite header mismatch seperti di bawah ini

SQLite header and source version mismatch
2011-11-01 00:52:41 c7c6050ef060877ebe77b41d959e9df13f8c9b5e
2012-06-11 02:05:22 f5b5a13f7394dc143aa136f1d4faba6839eaa6dc

Jika ada error, coba lakukan

apt-get remove --purge sqlite3 libsqlite3-dev
apt-get install sqlite3 libsqlite3-dev
cp /usr/bin/sqlite3 /usr/local/bin/


Pranala Menarik

Secara Umum

Instalasi Linux

Command Line Interface

Repository & Penggunaannya

Instalasi Aplikasi

Compile Kernel

Remaster Linux

Sistem Operasi untuk Embedded

Membuat Firmware Sendiri

Flash ke Device

Beberapa Tip

Tuning Kernel

Tuning Kernel Scheduler

Tuning I/O Scheduler

Tuning Manajemen Memory

Android

Membuat Kernel Module

Monitoring & Benchmark