This forum has been archived. All content is frozen. Please use KDE Discuss instead.

POLL: What database do you use?

What database backend do you use with Amarok?

Poll runs till Sun May 10, 2043 7:38 am

SQLite
32%
MySQL
56%
PostgreSQL
12%
Don't know
No votes
Real men use MyPostgreSQLite!
No votes

Total votes : 25


Tags: None
(comma "," separated)
User avatar
markey
KDE Developer
Posts
2286
Karma
3
OS

POLL: What database do you use?

Fri Sep 01, 2006 3:48 pm
Polls are fun :) Provide us a little feedback.

Note: If you don't know what you are using, it's probably SQLite (the default).

Last edited by Anonymous on Fri Sep 01, 2006 3:51 pm, edited 1 time in total.


--
Mark Kretschmann - Amarok Developer
User avatar
Jarsto
Registered Member
Posts
42
Karma
0
OS

Re: POLL: What database do you use?

Fri Sep 01, 2006 7:09 pm
I'm afraid I just use play SQLite. But I like the sound of "MyPostgreSQLite!" and would like to hear more :D


Jarsto

"There are three rules for writing a novel. Unfortunately, no one knows what they are."
W. Somerset Maugham
User avatar
s|mon
Registered Member
Posts
13
Karma
0

Re: POLL: What database do you use?

Fri Sep 01, 2006 9:01 pm
I started using mysql as i began with amarok.
Then when a friend told me about some of the faults of mysql (with respect to database aspects, not important for amarok) i said why not try something different.
So i installed postgresql imported my data (who wants to lose his stats) and i'm happy.
I don't remember any problems since i switched (not that there where many before)

So thanks for Amarok and keep up the good work 
LensCap
Registered Member
Posts
3
Karma
0

Re: POLL: What database do you use?

Mon Sep 04, 2006 3:21 am
can the amaroK postgres/mysql databases import from the SQLite as well?
User avatar
tante
Registered Member
Posts
47
Karma
0

Re: POLL: What database do you use?

Mon Sep 04, 2006 12:45 pm
LensCap wrote:can the amaroK postgres/mysql databases import from the SQLite as well?

If you have sqlite installed on your computer you can "connect" (as in open) the sqlite database with it and use ".dump" to export it into a format that postgresql can import (more here: http://www.sqlite.org/sqlite.html)


"Governments can be useful to the governed only so long as inherent
tendencies toward tyranny are restrained."
Frank Herbert, 'God Emperor Of Dune'
Soap
Registered Member
Posts
14
Karma
0

Re: POLL: What database do you use?

Mon Sep 04, 2006 9:59 pm
s|mon,

I was actually the opposite. I started with postgresql, but it would give me problems.  Amarok couldn't access the DB after I restarted the computer (yes, I had postgresql start on boot).

I switched over to MySQL and haven't had a problem since.


Soap
User avatar
s|mon
Registered Member
Posts
13
Karma
0

Re: POLL: What database do you use?

Tue Sep 05, 2006 6:22 pm
Hm maybe an issue caused by an update between pg versions, but as you already migrated there is no reason is making suspicions.
And as long as Amarok supports all these we'll all be happy ;)

Lenscap: you should have a look in the wiki, there are (unsupported) ways to migrate your data. And when you make backups there should be no problem.
see: http://amarok.kde.org/wiki/MySQL_HowTo#SQLite_-.3E_MySQL
I guess it will be analogous for postgres.
Headrush
Registered Member
Posts
4
Karma
0

Re: POLL: What database do you use?

Mon Oct 09, 2006 1:57 pm
SQLite.
On my small 3000 MP3 collection the SQLite method is significantly faster. Using MySQL introduces lengthy (second or two) pauses between songs.

(Modern hardware)


Bookmarks



Who is online

Registered users: Bing [Bot], Google [Bot], Yahoo [Bot]