Feedreader.com - Open/Read/Extract data from rssengine.fdb - Comments

bjtoglg

andy706 — Wed, 09 Dec 2009 06:21:39 +0200

zasunza

"Backup/Tidyup is working

ingmar — Thu, 15 Nov 2007 19:01:13 +0200

"Backup/Tidyup is working just fine - making my app obsolete :("

No sad faces;)

You can always create new utilities that are working better then FR's:))

We decided, that we'll include in FR3.12 new feature,
when computer is onidle (no keyboard, mouse activity - for example 30 min),
then once in a day cleaning is triggered. Maybe also automatic backup.

So we are trying to give our best;)

Ingmar

------
FR dev

Thanks for replying and supporting FR related applications

MehdiAnis — Thu, 15 Nov 2007 02:07:39 +0200

Hi,
Now, I understand why the articles were saved without Title - I guessed something like that too.

About "Best way to keep DB small, is to run FR backup utility. (Tidy up database) this will remove deleted records"

I think: I am using FR from 3.08 to 3.11. I have merged/imported OPML files several times. Moreover, i have experienced DB corruption few times. So some how Backup/TidyUp was not clearing old deleted articles. Once I used my app to clean those orphan articles Backup/Tidyup is working just fine - making my app obsolete :(

My guess is, if Backup/Tidyup is not reducing DB size then there is some problem. It is necessary to delete the orphan articles manually for once. I hope not too many people are in this situation. Thanks.

Mehdi Anis

Sorry, for the late

ingmar — Tue, 06 Nov 2007 11:26:36 +0200

Sorry, for the late replay

Yes, you are correct, valid articles are, where deleted field = 0

Those deleted(marked) records will be removed after some. Those records are empty (body,title,summary = ''), only guid, md5 is preserved.

Why this delete record is preserved?

For example you take some feed, todays news there are some items that you don't like. You will delete them. But tomorroy those articles are still in the feed, FR must keep track, ok those articles are in feed, but they are deleted.

If we delete those records, then you may receive again deleted records as "new" articles.

Best way to keep DB small, is to run FR backup utility. (Tidy up database) this will remove deleted records (that are safe to delete).

If you do also fullbackup and restore, then you have clean(unfragmented) DB.

Also feed and article title db field is varchar(512) utf8 collation.

But, every new FR utility is welcome;)))

Ingmar

------
FR dev

My Bad! Nothing wrong with TITLE field, there was no text

MehdiAnis — Tue, 06 Nov 2007 02:20:58 +0200

It was my mistake! I was querying All Rows WHERE DELETED = 1. The thing is, all rows that are marked for DELTED(=1) do not have any TITLE text. That's why I was getting empty string.

Anyway, if my finding helps anyone, I will be happy.

By the way, I have created a small .NET application that would delete orphan or other articles. If anyone interested feel free to email me : Mehdi.Anis@gMail.Com

Regards,
Mehdi Anis

Correction on reading TITLE column from ARTICLES table

MehdiAnis — Mon, 05 Nov 2007 22:00:36 +0200

Hi,
I made a mistake in my earlier post. The TITLE filed is varchar(2048), but the LINK filed is varchar(4000)

So, LINK field which is 4000 char max is being read by the .NET adapter. But TITLE field, which is 2048 char max long, is not being read. So, definitely it is not the MAX length issue. By the way, none of TITLE or LINK has any value that is that LONG.

So, I am at a loss now. Why can't my .NET app show the TITLE field?

Any help will be appreciated. Thanks.

Regards,
Mehdi Anis

Opened DB, problem reading TITLE column from ARTICLES table

MehdiAnis — Thu, 01 Nov 2007 17:15:32 +0200

Thanks for UserName/Password. Now I could open the database in my .NET app. I can read the ARTICLES table. Unfortunately, for some reason I can't get the TITLE field. Title Field for all rows returns Empty.

I am using: FirebirdSql.Data.FirebirdClient.dll
Ver: 2.5.0.0

Code part:
======================================
Dim CmdString As String = "SELECT ARTICLES.ID AS ID, FEEDS.TITLE AS FEED, ARTICLES.CREATED AS CREATED, " & _ "ARTICLES.TITLE AS TOPIC, ARTICLES.LINK AS LINK FROM ARTICLES LEFT JOIN FEEDS on ARTICLES.FEED_ID " & _ "= FEEDS.FEED_ID WHERE " & WhereClause


        Dim FdbCmd As New FbCommand(CmdString, FdbConn)
        Dim myDataAdapter As New FbDataAdapter(FdbCmd)

Try Dim custDS As DataSet = New DataSet myDataAdapter.Fill(custDS, "ARTICLES")
==========================================

I get ID, Created, Feeds, Link but no text for TITLE. If I use, Marathon software I can see the Text for TITLE column. Title field is nvarchar(4000), is it too big for .NET provider?

It's not a FeedReader's bug or problem. But if some one can help me as volunteer basis that will be great. Thanks for your time.

Regards,
Mehdi Anis

fdb...

strom — Sun, 23 Sep 2007 01:51:58 +0300

Cool reader...

but why i cant use export options? xml or html or csv...

or better get ac?ess to data base using working login and password...

(not SYSDBA and masterkey)?

Username for database is

tom-admin — Sat, 25 Aug 2007 13:27:44 +0300

Username for database is SYSDBA and password is MASTERKEY. This is standard Firebird SQL Server username.

rssengine.fdb UserName/PassWord

MehdiAnis — Fri, 24 Aug 2007 22:16:17 +0300

How can I get UserName and PassWord to conenct to FeedReader's Database, 'rssengine.fdb' ?

Is there any default username/password that I can use from a .NET app?

rssengine.fdb seems to be password protected

MehdiAnis — Fri, 24 Aug 2007 22:14:53 +0300

Thanks for sharing the link

http://www.firebirdsql.org/index.php?op=files&id=netprovider

which helps opening a FireBird database from .NET and other application. I tried the .NET plug-ins and ODBC driver. It works with a FireBird database.

But the FeedReader's database 'rssengine.fdb' is password protected. I can not access the FeedReader database with the Default FireBird username/password.

I do not know the UserName/Password to conenct to FeedReader's database.

Advance thanks for ideas.

OPML export or read directly

ingmar — Fri, 24 Aug 2007 17:08:08 +0300

OPML export or read directly from DB

http://www.firebirdsql.org/index.php?op=files&id=netprovider

Ingmar

Open/Read/Extract data from rssengine.fdb

MehdiAnis — Sat, 18 Aug 2007 01:04:15 +0300

Is there any existing way to Open/Read/Extract information from rssengine.fdb file?

I am looking for a way to use the rssengine.fdb file in another .NET app that I am developing. Will you allow such use? If not, is there a way to export feeds to CSV or Excel or some other file type from FeedReader program?

Thanks for your reply.