07-25-2003
I found SQLite (
http://www.sqlite.org/) quite fast. It's fast even on a Pentium I I have used. There's not as much goodies as MySQL/postgreSQL though but it's good for, say, a small C++/perl program that needs database storage but you don't want to install a hefty database server like MySQL. Its data goes into files that you can move around in your hard disk freely, not in centralized database server.
Otherwise, I recommend MySQL. phpMyAdmin is a nice tool to maintain it.
9 More Discussions You Might Find Interesting
1. Programming
help me in using database in c++
whether datas entered in c++ can be
stored in Oracle or access database?
give a hint (1 Reply)
Discussion started by: sajin_george
1 Replies
2. Programming
THis is my program
#include <stdio.h>
#include "sqlext.h"
#include "sql.h"
#include <string.h>
#include<errno.h>
// #include "sqlunix.h"
#define STR_LEN 30
#define SQL_NTS (-3)
#define MYSQLSUCCESS(rc) ((rc==SQL_SUCCESS)||(rc==SQL_SUCCESS_WITH_INFO))
... (8 Replies)
Discussion started by: ramneek
8 Replies
3. Linux
Hai ,
can any one suggest me any site where the mysql tutor for linux is avialable i am new to the linux mysql so i want to know right from the basics and how can i connect those database to planner tool in linux
:)
Regards
Sanju (1 Reply)
Discussion started by: sanjustudy
1 Replies
4. Programming
how can we connect to database(psql) using c language?.
Any one help.Pls say the hader file and function's avilable in C for database operation(like connecting,selecting,etc...). (3 Replies)
Discussion started by: sabari
3 Replies
5. UNIX for Dummies Questions & Answers
i've got a database setup that references user inputs to see if they are already inputted. What I am wanting to do is allow the user to update the database by typing
"update: name" where name is someone already in the database.
echo "Enter your name."
read NAME
location=`find . -name... (2 Replies)
Discussion started by: fufaso
2 Replies
6. Solaris
hi..
i have a need .. my php runs on my linux redhat box with mysql.. i want my php code to refer another mysql database
which is in solaris 10 x86... can u tell me the procedure ..
how it can be done through php .. sorry am new to php...
is it possible to redirect from linux mysql to... (7 Replies)
Discussion started by: senkerth
7 Replies
7. Solaris
I installed Oracle 10 software on Solaris 11 Express, everything was fine execpt I can't create database using dbca.rsp file. I populated file with following options.
OPERATION_TYPE = "createDatabase"
GDBNAME = "solaris_user.domain.com"
SID = "solaris_user"
TEMPLATENAME = "General... (0 Replies)
Discussion started by: solaris_user
0 Replies
8. Shell Programming and Scripting
How to find out whether your database is down or not?
Could anyone provide me the command please..
Thanks
C (6 Replies)
Discussion started by: bobby1015
6 Replies
9. Shell Programming and Scripting
I have a reseller account with hostgator, which means i have WHM and Cpanel. I have set up a staging environment for one of my wordpress installations (client website), which is essentially sitting at staging.domain.com (live site is at domain.com). The staging website is a complete copy of the... (1 Reply)
Discussion started by: nzrobert
1 Replies
LEARN ABOUT DEBIAN
grass-sqlite
grass-sqlite(1grass) Grass User's Manual grass-sqlite(1grass)
NAME
grass-sqlite - SQLite driver
SQLite driver SQLite driver in GRASS
Creating a SQLite database
GRASS is automatically creating the SQLite database if it is not yet existing when the first table is created in the SQLite database. It is
sufficient to define the connection (see next step).
Connecting GRASS to SQLite
The database name 'sqlite.db' is at user's choice. Also the file storage location can be freely chosen. If the database does not exist, it
will be automatically created when database content is created:
# example for storing DB in mapset directory (keep single quotes):
db.connect driver=sqlite database='$GISDBASE/$LOCATION_NAME/$MAPSET/sqlite.db'
db.connect -p
Supported SQL commands
All SQL commands supported by SQLite (for limitations, see SQLite help page: SQL As Understood By SQLite and Unsupported SQL).
Operators available in conditions
All SQL operators supported by SQLite.
Browsing table data in DB
A convenient SQLite front-end is sqlitebrowser. To open a DB file stored within the current mapset, the following way is suggested (corre-
sponds to above database connection):
eval `g.gisenv`
# use double quotes:
sqlitebrowser "$GISDBASE/$LOCATION_NAME/$MAPSET"/sqlite.db
SEE ALSO
db.connect, db.execute, db.select
SQL support in GRASS GIS
SQLite web site, SQLite manual, sqlite - Management Tools
Last changed: $Date: 2011-02-07 18:59:50 +0100 (Mon, 07 Feb 2011) $
Help Index
GRASS 6.4.2 grass-sqlite(1grass)