![]() KDE Developer ![]()
|
Polls are fun
![]() 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 |
![]() Registered Member ![]()
|
I'm afraid I just use play SQLite. But I like the sound of "MyPostgreSQLite!" and would like to hear more
![]()
Jarsto
"There are three rules for writing a novel. Unfortunately, no one knows what they are." W. Somerset Maugham |
![]() Registered Member ![]()
|
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 |
![]() Registered Member ![]()
|
can the amaroK postgres/mysql databases import from the SQLite as well?
|
![]() Registered Member ![]()
|
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' |
![]() Registered Member ![]()
|
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
|
![]() Registered Member ![]()
|
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. |
![]() Registered Member ![]()
|
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) |
Registered users: Bing [Bot], Google [Bot], Yahoo [Bot]