sqlite3

    sqlite3



    



PHP




ii  php7.4-sqlite3 7.4.16-1ubuntu2 amd64        SQLite3 module for PHP


コラムが大文字





# pacman -S php-sqlite

/etc/php/php.ini

	

	extension=pdo_sqlite.so

	




Python






Perl



	libclass-dbi-sqlite-perl


	# pacman -S perl-dbd-sqlite




Ruby




ii  ruby-dbd-sqlite3    1.2.5+gem2deb-2    all    Ruby/DBI SQLite3 driver
ii  ruby-sqlite3        1.3.8-2            amd64  SQLite3 interface for Ruby






$ gem install sqlite3




Tcl



/usr/lib/tcltk/sqlite3/pkgIndex.tcl

	

	package ifneeded sqlite3 3.7.9 \

    [list load [file join $dir libtclsqlite3.so] sqlite3]

	

Arch Linux

	

	# pacman -S sqlite-tcl

	




Haskell




ii  libghc-hdbc-sqlite3-dev   2.3.3.0-3build1  amd64        Sqlite v3 HDBC (Haskell Database Connectivity) Driver for GHC






Gauche



	Gauche-dbd-sqlite3-0.1.3.tgz


	./configure

	make

	sudo make install




Ocaml




ii  libsqlite3-ocaml      1.5.6-3build1	Embeddable SQL Database for OCaml Programs
ii  libsqlite3-ocaml-dev  1.5.6-3build1	Embeddable SQL Database for OCaml Programs






	ocaml-sqlite3-release-1.5.8.tar.bz2

	$ yaourt -Sb ocaml-sqlite3




Tcl



	libsqlite3-tcl




go



	export GOPATH=/home/uchida/gocode

	go get github.com/mattn/go-sqlite3




node.js



# ln -s /usr/bin/nodejs /usr/bin/node

# npm install sqlite3





Java



	sqlite-jdbc-3.7.2.jar


	Arch Linux

	

	# pacman -S javasqlite

	





C#



/usr/lib/mono/2.0/Mono.Data.Sqlite.dll







$ sqlite3 cities.db 
SQLite version 3.21.0 2017-10-24 18:55:49
Enter ".help" for usage hints.
sqlite> .schema
CREATE TABLE cities (id varchar(10) primary key, name varchar(20), population int, date_mod date);
sqlite> .quit


















result_aa




outarea_aa


outarea_bb


outarea_cc


outarea_dd


outarea_ee


outarea_ff


outarea_gg


outarea_hh



Return

May/09/2023 AM 08:15