We're researching this project and are looking for quotes to see how much it would cost. Please include a time estimate in your proposal.
## Overview
The goal of the Unicode Reader is to build an RSS reader that brings in multiple RSS feeds which contain diverse Unicode characters and save the individual posts to a table in a PostgreSQL database. The posts can then be viewed and read in the Unicode Reader. This is a prototype - the end result does not require a huge amount of polish but should look reasonably similar and function as closely as possible unless otherwise noted in this specification.
### Key Features
- Database Usage
- XML Parsing
- Unicode Character IO
### PostgreSQL
The PostgreSQL database should be installed on the same machine as the desktop client. The RSS reader should be loading from localhost. The drivers should all be correctly configured to support Unicode and the database and tables should also be configured to support Unicode.
### Default Feeds
https://blogs.embarcadero.com/feed/
https://blogs.embarcadero.com/ja/feed/
https://blogs.embarcadero.com/de/feed/
https://blogs.embarcadero.com/ru/feed/
https://blogs.embarcadero.com/pt/feed/
https://blogs.embarcadero.com/es/feed/
## Schemas
The schemas aren’t set in stone. If you think something doesn’t make sense or needs to be changed (added or removed), let us know so we can keep the schema in sync across different platforms.
### Channels Schema
```sql
create table channels (
id serial,
title varchar(1024) not null,
description text not null,
link varchar(2048) not null,
constraint channels_pk primary key (id)
);
```
### Articles Schema
```sql
create table articles (
id serial,
title varchar(1024) not null,
description text not null,
link varchar(2048) not null,
is_read boolean default false,
timestamp timestamp default now(),
channel integer not null,
constraint articles_pk primary key (id),
constraint channels_fk foreign key (channel)
references channels (id)
on delete cascade
);
```
### Login Info
Username: postgres
Password: postgres
Server: 127.0.0.1
DBName: postgres (or just the default?)
## Requirements
### Layout
The Unicode Reader is broken down into three sections. The left section contains the list of feeds. The middle section contains the list of posts from the selected Feed (or All Feeds if selected). The left and middle sections are a fixed width. The right section takes up the rest of the client and displays the contents of the post itself. In theory the contents of the post should be loaded into an HTML frame since they will contain HTML. It should not load the URL of the post but load the post itself. Any links should open in the Desktop browser (target=_blank).
### Light And Dark Theme
The Unicode Reader should offer a Light theme and a Dark theme (see attached images). The Dark theme should be default.
## Deliverables
Complete source code for your working Unicode Reader. Include a compiled executable if applicable or instructions for executing the code if not.
