Software Wishlist

I figure programmers visit this place and may need some ideas for programs.

Here is what I am currently working on for the J720:

1. a RSS reader prog
2. Note taker with the SQLCE 2.0 db as the backend
3. Schannel Root Certificate update (using the 128-bit HPC Pro update)for the SH4(due to a request)
The SA110 and Mips patch already completed and tested

no guarantee I will finish the first two but who knows

My wishlist
1. Beefed up Internet Explorer w/ right click functionality


Nathan

Why do you want a SQLCE backed Note taker applciation?

It would be a huge install, very expensive, slow on legacy devices, difficult to troubleshoot and a nightmare to backup!!

Just wondering?

um mainly targetd at the J720

1.5mb installation (for sqlce itself) imho it is worth the space considering you get access to a full fledged db
where the datafile can sit on a compact flash

expensive? it's free as long as you dont connect to a SQL server.

Not targeted at legacy devices unless requested. In that case, flip over
to the window ce db api or flat files i guess
Do not see it slow considering this is pure c/c++ code
But this will forward compatible

hard to troubleshoot? never had a problems yet

nightmare to backup? not sure why it would be difficult.( run a system cmd to copy the database file)

install a webserver and instant access to your stuff through the network (well im dreaming here)

Nathan

Ah well now I see. You're looking at a nice techy application.

Alas there is little in the way of real commercial prowess in having it back ended on SQL server. I cannot see any reason why the built in JET engine couldn't handle such an application.

You're thinking from the persepctive of a technical user. That's cool. When it comes to troubleshooting an end user against a engine with the power of MSSQL. There are too many variables to go wrong. It's be like giving someone the SQL engine against the old 3.11 card file app.
Just look at all the trouble MS have had with the release of Outlook 2003 BCM which upgrades Outlook 2003 to run under MSDE. That applications caused no end of problems.
Completly hozed both it's version and my PST file in less than 36 hours. Luckily backups were to hand to revert back to JET.

In order to have a end user backup, you would have to have a sync engine. I don't think you would be able to sync the SQL CE with another database format on the PC.

Also, just to add. Developing for a single device over that of the entire platform has historically been a huge mistake on the part of the developer.

It's a great geek idea though

um

the adoce path is not viable through c/c++
the ole way is preferred(and faster)
adoce is great but you have to use vb or .net
at the cost of space and performace

The trick to trouble shooting a user against the engine is to control all
points data flow(ie tested constant sql statements and error checking/recovery)
by splitting into three parts (frontend(GUI), middle(verify and perpare sql), backend(store data))
and limiting what a user can do against the engine. Ideally, the user will not know the backend is
a sqlce db, ce db api or even a flat file. All the user will "know" is the note taking part. So
the only true troubleshooting part with the user will be with the GUI.

Not to say it will be easy but heavy testing is always a requirment
Im not upgrading a appliction but creating one

not true regarding the user backup.
the user can use the activesyc and the option of synchronized files
or
syscmd to back up to a compactflash or any other removable media
or
email the file away

it wont be able to sync the SQL CE with another database because it would cost a license to use that capability
I leave that up to the user to decide if they need to sync with a database or not.

it's good security if nothing else can read your datafile

This is a forward compatible application ie this app will be usable on future versions of ce. I only got 2 devices
so I target the ones I have.

Nathan