SQLite support

Development-related discussion, including bundled plugins
harshdeep
Bear Rating Trainee
Bear Rating Trainee
Posts: 1
Joined: 31 Mar 2013, 21:00

SQLite support

Postby harshdeep » 31 Mar 2013, 21:05

Hi Team,

TTRSS is really handy tool, but on Raspbarry Pi it is running very slow because MySQL running on SD card is becoming bottlenack. I am sure it has been in to-do list bust just wanted to toss an idea of SQLite as back-end, as it might improve performance on Raspbarry Pi (and/or low end machines)

Thanks,
Harshdeep Mehta

User avatar
fox
^ me reading your posts ^
Posts: 6318
Joined: 27 Aug 2005, 22:53
Location: Saint-Petersburg, Russia
Contact:

Re: SQLite support

Postby fox » 31 Mar 2013, 23:39

tt-rss actually uses database functionality beyond glorified grepping with sql syntax, so I'm afraid this ain't happening any time soon.

cy8aer
Bear Rating Master
Bear Rating Master
Posts: 110
Joined: 19 Apr 2010, 13:29

Re: SQLite support

Postby cy8aer » 31 Mar 2013, 23:57

Some years ago I changed from MySQL to Postgres. After this tt-rss went smoother. That was on a 500MHz VIA Epia box, so nearly the performance of a raspi. Maybe this will help...

joseph-mx
Bear Rating Disaster
Bear Rating Disaster
Posts: 68
Joined: 19 Oct 2012, 05:19
Location: http://www.mxhub.com/reader/
Contact:

Re: SQLite support

Postby joseph-mx » 01 Apr 2013, 03:36

cy8aer wrote:Some years ago I changed from MySQL to Postgres. After this tt-rss went smoother. That was on a 500MHz VIA Epia box, so nearly the performance of a raspi. Maybe this will help...


hmm..Postgres perform better than mysql?
i am not sure..

:shock: :shock:

i am still a fan of mysql. Perhap, you can look into optimize the mysql settings.. add in caching.. might help improve performance.

User avatar
fox
^ me reading your posts ^
Posts: 6318
Joined: 27 Aug 2005, 22:53
Location: Saint-Petersburg, Russia
Contact:

Re: SQLite support

Postby fox » 01 Apr 2013, 08:33

>i am still a fan of mysql.

There's your problem right there. :)

User avatar
lordofthemoon
Bear Rating Trainee
Bear Rating Trainee
Posts: 10
Joined: 01 Apr 2013, 22:36
Location: Glasgow
Contact:

Re: SQLite support

Postby lordofthemoon » 01 Apr 2013, 22:39

I just set up TT-RSS on an RPi today and I was finding MySQL to be awfully slow as well. I nuked my installation and configured MySQL to use the MyISAM engine rather than InnoDB. This has sped up performance no end, although at some costs.

User avatar
fox
^ me reading your posts ^
Posts: 6318
Joined: 27 Aug 2005, 22:53
Location: Saint-Petersburg, Russia
Contact:

Re: SQLite support

Postby fox » 01 Apr 2013, 22:46

>although at some costs.

You are about to have some major fun without foreign keys or transactions or delete cascade or anything really.

Edit: I actually went ahead and tried it, it was pretty hilarious.

User avatar
lordofthemoon
Bear Rating Trainee
Bear Rating Trainee
Posts: 10
Joined: 01 Apr 2013, 22:36
Location: Glasgow
Contact:

Re: SQLite support

Postby lordofthemoon » 01 Apr 2013, 23:13

You are about to have some major fun without foreign keys or transactions or delete cascade or anything really.

Yeah, I know about the limitations, but it was just about unusable on the RPi with InnoDB. I'll not be doing any major development or anything on it, just using it to run TT-RSS :).

User avatar
fox
^ me reading your posts ^
Posts: 6318
Joined: 27 Aug 2005, 22:53
Location: Saint-Petersburg, Russia
Contact:

Re: SQLite support

Postby fox » 01 Apr 2013, 23:15

Create a category, put a feed into it, delete category. Minor hilarity ensues.

gerhardy2408
Bear Rating Trainee
Bear Rating Trainee
Posts: 3
Joined: 05 Oct 2013, 19:05

Re: SQLite support

Postby gerhardy2408 » 23 Dec 2013, 00:59

Hi,

I'm also using a Raspberry Pi, and have a few DBs running with mySQL (WordPress, roundcube, owncloud, piwik), and all are running wonderful with the MyISAM engine. And as the RPi has only 512MByte of RAM I want to get rid of the InnoDB engine for mySQL, as it is claimed that a lot of memory is used by it. The mySQL process grabs 20% of my memory! And I still need to run Apache, ...
And the lovely tt-rss is the only DB for that I still need the InnoDB engine.
How can I get rid of that? Which tables I have to alter and what are the drawbacks using MyISAM?
Another option would be to install another Pi just for running the mysql server :-(
Any other ideas are welcome!

Thanks!

Gerhard

User avatar
fox
^ me reading your posts ^
Posts: 6318
Joined: 27 Aug 2005, 22:53
Location: Saint-Petersburg, Russia
Contact:

Re: SQLite support

Postby fox » 23 Dec 2013, 01:42

I have an idea: what if you read a bit before posting further.


Return to “Development”

Who is online

Users browsing this forum: No registered users and 3 guests