sqlite install in windows 64bits

1. Download from sqlite  https://sqlite.org/download.html

sqlite-dll-win64-x64-3140100.zip
sqlite-tools-win32-x86-3140100.zip

2. Create Folder and unzip 

.mkdir  in C:\sqlite
.unzip above  two zip

3. launch the sqlite 

cd c:\sqlite
sqlite3.exe

SQLite version 3.14.1 2016-08-11 18:53:32
Enter ".help" for usage hints.
Connected to a transient in-memory database.
Use ".open FILENAME" to reopen on a persistent database.

4. How to use 

.open test.sqlite

CREATE TABLE users (id integer primary key autoincrement, name text not null);

insert into users (name) values('jon');
insert into users (name) values('paul');

sqlite> select * from users;
1|john
2|paul

the .open is the command for create/connection database
other .tables or .drop



Reference :
First_Installing-and-Using-SQLite-on-Windows
Appropriate Uses For SQLite
SQLite vs MySQL

pgAdmin Install

Postsql DB

http://blog.secaserver.com/2012/01/linux-install-configure-postgresql-with-pgadmin/

3 . pgAdmin Install :

Install:

a . downlaod http://packages.sw.be/rpmforge-release/rpmforge-release-0.5.2-2.el6.rf.x86_64.rpm

b . rpm --import http://apt.sw.be/RPM-GPG-KEY.dag.txt

Ref:

http://wiki.centos.org/AdditionalResources/Repositories/RPMForge

http://wiki.centos.org/AdditionalResources/Repositories/RPMForge

http://blog.secaserver.com/2012/01/linux-install-configure-postgresql-with-pgadmin/

最後:

0 . 先裝 pgdg91 from http://ag-up.com/?p=524

2 . yum clean

b . 再裝 postsql

{{{

yum install -y postgresql* 

}}}

http://blog.secaserver.com/2012/01/linux-install-configure-postgresql-with-pgadmin/

重要篇(important)

http://www.davidghedini.com/pg/entry/install_postgresql_9_on_centos

http://www.tekography.com/tutorials/linux/postgresql-database-server-9-1-centos/

office

http://www.pgadmin.org/download/rpm.php

c .

root@localhost pgAdmin]# yum search pgAdmin

Loaded plugins: fastestmirror, refresh-packagekit, security

Loading mirror speeds from cached hostfile

* base: mirror01.idc.hinet.net

* extras: mirror01.idc.hinet.net

* rpmforge: mirror.fairway.ne.jp

* updates: mirror01.idc.hinet.net

=================================================================================== N/S Matched: pgAdmin ====================================================================================

pgadmin3_91-debuginfo.x86_64 : Debug information for package pgadmin3_91

pgadmin3_91-docs.x86_64 : Documentation for pgAdmin3

pgadmin3_91.x86_64 : Graphical client for PostgreSQL

phpPgAdmin.noarch : Web-based PostgreSQL administration

Name and summary matches only, use "search all" for everything.

[root@localhost pgAdmin]# yum install pgadmin3_91.x86_64

Loaded plugins: fastestmirror, refresh-packagekit, security

Loading mirror speeds from cached hostfile

* base: mirror01.idc.hinet.net

* extras: mirror01.idc.hinet.net

* rpmforge: mirror.fairway.ne.jp

* updates: mirror01.idc.hinet.net

Setting up Install Process

Resolving Dependencies

--> Running transaction check

---> Package pgadmin3_91.x86_64 0:1.14.2-1.rhel6 will be installed

--> Finished Dependency Resolution

Dependencies Resolved

=============================================================================================================================================================================================

Package Arch Version Repository Size

=============================================================================================================================================================================================

Installing:

pgadmin3_91 x86_64 1.14.2-1.rhel6 pgdg91 6.0 M

Transaction Summary

=============================================================================================================================================================================================

Install 1 Package(s)