Withdata Software

Parse online RSS feeds and save to MariaDB

Want to parse online RSS feeds and save to MariaDB? Want to schedule and automate this importing task?

Try Withdata FileToDB, a desktop RSS to MariaDB converter for Windows, MacOS, and Linux, Import online RSS feeds to MariaDB, Easy and Fast.

Download Withdata FileToDB
Windows 64 bit
Windows 32 bit
Linux .deb (For Debian, Ubuntu) 64 bit
Linux .rpm (For Red Hat, Fedora, SUSE) 64 bit
MacOS 64 bit

Import online RSS feeds to MariaDB

Choose MariaDB and logon.

Click “Wizard – 1 File To 1 Table” at task dialog.

Select “Source Type” with “Url”.

then show the wizard.

1. Input the RSS feeds URL, and download to XML file.

2. Open the saved XML file.

3. Config target MariaDB table.

You can create new MariaDB table by XML struct, just a few mouse clicks.

Select table and config fields.

4. Preview data will be in MariaDB table.

5. Import RSS feed to MariaDB.

See importing results in MariaDB table


More about XML (RSS) to MariaDB converter

RSS → MariaDB reference

Type mapping

Value kindin RSSin MariaDB
Int<int>1234</int> or a child elementINT
Bigint<bigint>9007199254740993</bigint>BIGINT
Decimal<decimal>1234.56</decimal>DECIMAL(p,s)
Float<float>1.234e10</float>DOUBLE
Text<title>text</title>VARCHAR(n)
Long text<description>text</description>, usually wrapped in CDATALONGTEXT
Date<pubDate>Mon, 18 Sep 2026 00:00:00 GMT</pubDate> (RFC 822)DATE
Datetime<pubDate>Mon, 18 Sep 2026 14:30:00 GMT</pubDate> (RFC 822)DATETIME
Binaryan enclosure URL, never inline bytesLONGBLOB
Booleannot part of the feed vocabularyTINYINT(1)
JSONnot part of the feed vocabularyJSON

Dialect differences

RSS is a file format and MariaDB is a database server, so the target has to be told the types the file never carried - the rows below are where the two sides diverge.

Propertyin RSSin MariaDB
port—3306
identifiersXML quoting; content is usually escaped in CDATA`backtick`
row limit—LIMIT n
datesRFC 822 text, for example Mon, 18 Sep 2026 14:30:00 GMTDATETIME, TIMESTAMP, DATE, TIME
long text—TINYTEXT / TEXT / MEDIUMTEXT / LONGTEXT
binaryVia enclosure URLs, not inlineBLOB / TINYBLOB / LONGBLOB
separatorXML elements—
encodingDeclared in the XML declaration—
typingNone—
shapeChannel plus repeated <item> elementsTables of rows and columns
ceilingA feed is a window on recent items, not a full data set—

Command line

SideCommand
MariaDBmariadb-dump
MariaDB (load)mariadb-import, or LOAD DATA INFILE

Convert your data online, free

Free in-browser converters for CSV, Excel, JSON, XML and SQL: Withdata Online Data Conversion. Large files, batch conversion or scheduling? See the offline desktop apps, or browse all data conversion tools.