You are not logged in.

#1 2005-03-28 10:26:48

rasat
Forum Fellow
From: Finland, working in Romania
Registered: 2002-12-27
Posts: 2,293
Website

DB for linux

Reading topic about pacman with database, what DBs are available for linux? Pro & cons? Any DB works with bash?


Markku

Offline

#2 2005-03-28 10:44:56

cactus
Taco Eater
From: t͈̫̹ͨa͖͕͎̱͈ͨ͆ć̥̖̝o̫̫̼s͈̭̱̞͍̃!̰
Registered: 2004-05-25
Posts: 4,622
Website

Re: DB for linux

http://www.topology.org/images/sqldb.png

http://freshmeat.net/articles/view/307/
http://freshmeat.net/articles/view/305/
A bit old, but might have some useful info..

http://freshmeat.net/browse/66/

As for bash..it looks like sqlite is scriptable using the sqlite cli front end..
http://freshmeat.net/articles/view/1428/
I believe most of the other *dbm have similar properties.


"Be conservative in what you send; be liberal in what you accept." -- Postel's Law
"tacos" -- Cactus' Law
"t̥͍͎̪̪͗a̴̻̩͈͚ͨc̠o̩̙͈ͫͅs͙͎̙͊ ͔͇̫̜t͎̳̀a̜̞̗ͩc̗͍͚o̲̯̿s̖̣̤̙͌ ̖̜̈ț̰̫͓ạ̪͖̳c̲͎͕̰̯̃̈o͉ͅs̪ͪ ̜̻̖̜͕" -- -̖͚̫̙̓-̺̠͇ͤ̃ ̜̪̜ͯZ͔̗̭̞ͪA̝͈̙͖̩L͉̠̺͓G̙̞̦͖O̳̗͍

Offline

#3 2005-03-28 12:49:47

rasat
Forum Fellow
From: Finland, working in Romania
Registered: 2002-12-27
Posts: 2,293
Website

Re: DB for linux

smile... I think sqlite has the most RAM.

You do not have to enter the sqlite3 interactive environment. Instead, you could perform all commands at the shell prompt, which is ideal when running bash scripts and commands in an ssh string.


Markku

Offline

#4 2005-03-28 12:55:56

cactus
Taco Eater
From: t͈̫̹ͨa͖͕͎̱͈ͨ͆ć̥̖̝o̫̫̼s͈̭̱̞͍̃!̰
Registered: 2004-05-25
Posts: 4,622
Website

Re: DB for linux

no..taupe!


"Be conservative in what you send; be liberal in what you accept." -- Postel's Law
"tacos" -- Cactus' Law
"t̥͍͎̪̪͗a̴̻̩͈͚ͨc̠o̩̙͈ͫͅs͙͎̙͊ ͔͇̫̜t͎̳̀a̜̞̗ͩc̗͍͚o̲̯̿s̖̣̤̙͌ ̖̜̈ț̰̫͓ạ̪͖̳c̲͎͕̰̯̃̈o͉ͅs̪ͪ ̜̻̖̜͕" -- -̖͚̫̙̓-̺̠͇ͤ̃ ̜̪̜ͯZ͔̗̭̞ͪA̝͈̙͖̩L͉̠̺͓G̙̞̦͖O̳̗͍

Offline

#5 2005-03-28 13:03:46

lanrat
Member
From: Poland
Registered: 2003-10-28
Posts: 1,274

Re: DB for linux

Sqlite support is already present in many applications (including qt lib). It would allow nonprogrammers to use the db too.

Offline

#6 2005-03-28 13:06:27

cactus
Taco Eater
From: t͈̫̹ͨa͖͕͎̱͈ͨ͆ć̥̖̝o̫̫̼s͈̭̱̞͍̃!̰
Registered: 2004-05-25
Posts: 4,622
Website

Re: DB for linux

nonprogrammers know sql syntax?


"Be conservative in what you send; be liberal in what you accept." -- Postel's Law
"tacos" -- Cactus' Law
"t̥͍͎̪̪͗a̴̻̩͈͚ͨc̠o̩̙͈ͫͅs͙͎̙͊ ͔͇̫̜t͎̳̀a̜̞̗ͩc̗͍͚o̲̯̿s̖̣̤̙͌ ̖̜̈ț̰̫͓ạ̪͖̳c̲͎͕̰̯̃̈o͉ͅs̪ͪ ̜̻̖̜͕" -- -̖͚̫̙̓-̺̠͇ͤ̃ ̜̪̜ͯZ͔̗̭̞ͪA̝͈̙͖̩L͉̠̺͓G̙̞̦͖O̳̗͍

Offline

#7 2005-03-28 13:17:21

lanrat
Member
From: Poland
Registered: 2003-10-28
Posts: 1,274

Re: DB for linux

They don't have to. There are gui designers/front-ends.

Offline

#8 2005-03-28 13:40:26

rasat
Forum Fellow
From: Finland, working in Romania
Registered: 2002-12-27
Posts: 2,293
Website

Re: DB for linux

lanrat wrote:

There are gui designers/front-ends.

I am searching for GUI front-ends, anyone you recommend.
http://www.sqlite.org/cvstrac/wiki?p=SqliteTools


Markku

Offline

#9 2005-03-28 16:47:11

phrakture
Arch Overlord
From: behind you
Registered: 2003-10-29
Posts: 7,879
Website

Re: DB for linux

lanrat wrote:

They don't have to. There are gui designers/front-ends.

MS Access anyone?

Offline

#10 2005-03-28 21:28:03

cactus
Taco Eater
From: t͈̫̹ͨa͖͕͎̱͈ͨ͆ć̥̖̝o̫̫̼s͈̭̱̞͍̃!̰
Registered: 2004-05-25
Posts: 4,622
Website

Re: DB for linux

phrakture wrote:

MS Access anyone?

Arch based on MSAccess?
*cactus passes out*


"Be conservative in what you send; be liberal in what you accept." -- Postel's Law
"tacos" -- Cactus' Law
"t̥͍͎̪̪͗a̴̻̩͈͚ͨc̠o̩̙͈ͫͅs͙͎̙͊ ͔͇̫̜t͎̳̀a̜̞̗ͩc̗͍͚o̲̯̿s̖̣̤̙͌ ̖̜̈ț̰̫͓ạ̪͖̳c̲͎͕̰̯̃̈o͉ͅs̪ͪ ̜̻̖̜͕" -- -̖͚̫̙̓-̺̠͇ͤ̃ ̜̪̜ͯZ͔̗̭̞ͪA̝͈̙͖̩L͉̠̺͓G̙̞̦͖O̳̗͍

Offline

#11 2005-03-28 21:46:44

phrakture
Arch Overlord
From: behind you
Registered: 2003-10-29
Posts: 7,879
Website

Re: DB for linux

cactus wrote:

Arch based on MSAccess?
*cactus passes out*

TKO!

Offline

#12 2005-03-29 11:30:31

lanrat
Member
From: Poland
Registered: 2003-10-28
Posts: 1,274

Re: DB for linux

rasat wrote:
lanrat wrote:

There are gui designers/front-ends.

I am searching for GUI front-ends, anyone you recommend.
http://www.sqlite.org/cvstrac/wiki?p=SqliteTools

Search for my sql related posts (pkgbuilds) in "new and requested packages" forum.

Rekall (ms access like db) should soon have sqlite support:
http://rekall.no-no-badpuppy.com/module … ?storyid=2
(I hope it will replace xbase as standard format also in the free version of rekall).

Kexi from Koffice (rekall competitor):
http://www.koffice.org/kexi/

Another one from kde (I've never tried it though):
http://extragear.kde.org/apps/datakiosk/

You can find several web based projects for sqlite here:
http://www.linuxlinks.com/Web/Databases/

I think new versions of ooo will also support sqlite. There is an alpha driver at:
http://dba.openoffice.org/drivers/sqlite/index.html
Maybe the new oo base will somehow support sqlite too.

Gnome db
http://www.gnome-db.org/
says it supports sqlite so it should be usable with mergeant (front-end).

Perhaps there are more. Many applications are still in heavy development stage but should be usable. I guess kexi and rekall are the two most advanced. Everything depends on what kind of usage are you planning.

Offline

Board footer

Powered by FluxBB