Feedreader (3.12) MySQL Edition technology preview available

Submitted by tom-admin on Mon, 2008-01-07 07:51.

After days and weeks of hard work we are making Feedreader MySQL Edition available for testing and preview.

Feedreader MySQL is standard Feedreader that uses MySQL Server as database backend. In case of large number of feeds MySQL backend has better performance than our stock FirebirdSQL database. At the same time install and configuration is not that simple as in standard Feedreader. MySQL edition is more suitable for power users.

Feedreader MySQL Edition is not a free software. We will make it available for purchase in future. For active testers and users we will give out some licenses for free.

Download

Please download Feedreader MySQL Edition technology preview from here. While downloading preview release you should acknowledge that this version is far from production quality. It has bugs and sometimes crashes. This preview version expires on 1th of April. If you just want to try out MySQL edition but still continue running standard Feedreader then please install MySQL Edition to different directory from standard Feedreader.

Prerequisites

How to install

First install MySQL.
Select "typical" as installation type.
When asked select "configure mysql server now".
Select "standard configuration" as configuration type.
Check "install as windows service" and "launch mysql server automatically".
Uncheck "modify security settings". By default we will do without root password.
If mysql is not yet started then please start it from windows services control panel.
Install MySQL ODBC Connector.
Install Feedreader MySQL Edition.

Additional configuration options

If you have to use different login credentials than "root" as username and blank password then please specify login and password in feedreader.ini with configuration options:

mysql_dbLoginname
mysql_dbpwdPlain

Current preview release does not support changing password, so you are limited only to changing username.

Feedback

Your comments, ideas and another type of feedback is extremely helpful to us. So speak out!

» tom-admin's blog | login or register to post comments | 26759 reads

ctrl+alt+del

Submitted by GaGo on Thu, 2008-01-17 10:40.

while the feedreader window is open and you press ctrl+alt+del to get the taskmanager Feedreader asks to delete all selected items... if you said before (in the options) to always delete without asking confirmation feedreader just deletes the selected items.

» login or register to post comments

This will be fixed in

Submitted by tom-admin on Fri, 2008-01-18 07:12.

This will be fixed in release.

Greetings
Toomas

» login or register to post comments

greetings crew, thanks for

Submitted by Vidar2 on Fri, 2008-01-11 10:47.

greetings crew,

thanks for this :-) a really nice surprise and its looking very intersting...

i've been running it since monday and i have had NO hangs :-)
and overall it seems to respond in a good manner

but..the performance of the queries is not very good...i compared it to the firebird engine and there is quite a big difference...i converted my "old" db (feeds and smartfeeds) and these are some figures

SQL: ordinary feeds without any editing : 4 seconds
firebird: " : 0,2 seconds

SQL: "advanced" smartfeeds : 7 seconds
firebird: " : 0,6 seconds

so i really hope you can do some trimming..my firebird DB
contains about 75K articles and the SQL around 50K

errors: i have received errors when editing smartfeeds, so
FR has to be killed

i still don't get any notification with added importance

My CPU is still quite high, is that because i have several smartfeeds ? i thought maybe less CPU activity...

but as i said in the beginning, the overall performance is better...thats the feeling anyway, and what i mean by that is my computer seems not to that slow as earlier...

Request...can you please add Feedname doees NOT contain criteria

Question: how do i backup my data ?

best regards Vidar

» login or register to post comments

Greetings, in MYSQL the

Submitted by ingmar on Fri, 2008-01-11 11:14.

Greetings,

in MYSQL the speed depends how do you configure server.

test enviroment my.ini (MYSQL configuration file) contains following line

#*** INNODB Specific options ***
innodb_additional_mem_pool_size=5M
innodb_flush_log_at_trx_commit=0
innodb_log_buffer_size=3M
innodb_buffer_pool_size=32M
innodb_log_file_size=10M
innodb_thread_concurrency=8
innodb_lock_wait_timeout=65

-- innodb_buffer_pool_size=32M
more indexes are in memory, quicker you get results.

-- innodb_flush_log_at_trx_commit=0
less IO !

Could you describe those smartfeed errors ?
So I can fixit ...

There "can be" tons of errors...

I you are talking about MYSQL backups

http://dev.mysql.com/doc/refman/5.0/en/backup.html

With Firebird, is simple way to pack with zip RSSENGINE.FDB and copy it for example to CD.

It was quite a (nice) challange to add another backend to FR :))

Currently there are(Firebird,MSSQL,MYSQL)....

Ingmar
------
FR dev

» login or register to post comments

thanks understand it was a

Submitted by Vidar2 on Fri, 2008-01-11 11:51.

thanks

understand it was a challenge, but i'm very happy you did :-)

i tried to set a higer value in the innodb_buffer_pool_size=x
but nothing changed, do i have to restart my PC ?
how high can i go ? what other values can i increase (your suggestion) ?

this is a link to the error mess i get sometimes when editing SF..http://tinyurl.com/2gh98f

Vidar

» login or register to post comments

Greetings, all those

Submitted by ingmar on Fri, 2008-01-11 12:42.

Greetings,

all those variables are important;)

You must just restart MYSQL service, no computer restart required.

>how high can i go ?
I love this question (my testcomputer has only 512MB RAM):)))

Comments from my.ini file.

# InnoDB, unlike MyISAM, uses a buffer pool to cache both indexes and
# row data. The bigger you set this the less disk I/O is needed to
# access data in tables. On a dedicated database server you may set this
# parameter up to 80% of the machine physical memory size. Do not set it
# too large, though, because competition of the physical memory may
# cause paging in the operating system. Note that on 32bit systems you
# might be limited to 2-3.5G of user level memory per process, so do not
# set it too high.
innodb_buffer_pool_size = 2G

With FR MYSQL - the speed depends now how do you configure MYSQL server...

Also I hope, that soon there will be new MYSQL (stable) ODBC driver also...

Could You describe maybe in another forum thread,
support section, how did you get this access violation,
even minor detail is big help for us.

I would be very happy when there is a way, to reproduce this error...

Ingmar
------
FR dev

» login or register to post comments

thank you ingmar, speed much

Submitted by Vidar2 on Fri, 2008-01-11 13:21.

thank you ingmar,

speed much better now :-) (running xp limited account so had to "admin" and restart)

i will continue testing over weekend and give you an new "report" next week :-)

thanks

Vidar

» login or register to post comments

database convert

Submitted by shepik on Tue, 2008-01-08 22:21.

Can i somehow convert database created by feedreader connect or feedreader 3.11?

» login or register to post comments

Unfortunately this is not

Submitted by tom-admin on Wed, 2008-01-09 07:31.

Unfortunately this is not possible at this time. Backends of these products are really different and it takes quite a lot of time to create conversion application . I'm not saying that there will never be this kind of script - we just have to wait and see if there are plenty of users who will be using Mysql Edition.

At the same time you can use OPML Export and OPML import to export feeds from feedreader to Feedreader Mysql.

» login or register to post comments

Wow love MySQL Edition. But

Submitted by premois on Mon, 2008-01-28 14:37.

Wow love MySQL Edition. I'll definitely buy it if it works stable. But please is it somehow possible to import my old Smartfeeds? It has been so much work making the filter rules. Thx.

» login or register to post comments

Feedreader 3