On 7/6/16, John R. Sowden <jsow...@americansentry.net> wrote: > Q1: I am running xubuntu. When I > search for sqlite3, lots of things show up. This database engine seems > to be very popular, so I assume it is used my many programs on my > computer, like Thunderbird. Why, then when I enter sqlite3 at terminal > prompt do I get message saying that sqlite3 is not installed on my > computer.
You are confusing libsqlite3.so the library (used by everything) and "sqlite3", the command-line shell that one can use to access an SQLite database manually. Yes, lots and lots of things use SQLite. But usually they are using the library. Often they statically link against the library, so even the "libsqlite3.so" file is omitted. The "sqlite3" program is a handy tool used by humans to read or write an SQLite database file. The "sqlite3" program is installed by default on Macs and newer versions of Windows10, but apparently not on Xubuntu. The "sqlite3" program is statically linked against the sqlite3 library, but also includes other logic for interacting with the user through the command-line. > > Q2: I understand that this is not mariadb, etc. but I am unable to find > what specific features are not included in sqlite3. I understand the > big time stuff. I am currently using foxpro/dos for my database needs, > and it seems that sqlite3 and Pure Basic or Gambas is a good match for > me. I need multiple indices, support for about 5000 records, plus some > very small ones for validation, etc. > SQLite will do all of that. It's SQL support is on-par with MariaDB. SQLite supports up to 140 terabyte databases, 2 GB strings and blobs, unlimited numbers of rows per table. No practical limit on the number of tables and/or indexes, NOT NULL, UNIQUE, CHECK, and foreign key constraints, triggers, views, recursive common table expressions, indexes on expressions, JSON, etc. -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
