bounty $$$ for this exact database app
 

this is the app i want in the maemo world yesterday

http://www.androiddatabase.info/

i can put up $400 or my extra n900 to help get this done.

app should use latest available qt and be in c++ and be gplv2 with source

if there is someone who wants to tackle this please let me know here or by PM. i will set this project up on odesk or rentacoder or your choice of escrow money for code type services.

if you are a user who wants to help by increasing this bounty, i will find a way to do this in a responsible way with paypal or some type of escrow service online. i hope some will join as $400 is not very much in my opinion for this project, but it is a good chunk of a start

Re: bounty $$$ for this exact database app
 

I'm actually working on a project like this as we speak. However it will be in python/gtk initially, probably Qt when PR1.2 is available. Not wanting any money for it either.

Will see if I can post a preview soon. Probably by the end of next week. I have to figure out some stuff with regards to usability though, for example how do you display more than x columns? Implement scrolling? Etc. Will let you know how it goes.

Edit: The backend will be using SQLite3.

Re: bounty $$$ for this exact database app
 

Doesn't Glom function similarly?

Re: bounty $$$ for this exact database app
 

Looking at the link from OP and reading the following:
This suggests that any text based DB, like Berkeley DB, would be enough. Unless something special is meant by the lack of need for SQL...

Re: bounty $$$ for this exact database app
 

No, they simply explain that Android's native built-in database is used for performance, but that there is no requirement to know/use any kind of SQL language in order to use the application.

Re: bounty $$$ for this exact database app
 

yes, i checked out glom, but it currently cant create a new database on the device itself

also glomis mor concerned about presenting an input and presentation layer on top of the data making it kind of heavy and higher level than i would like.

Re: bounty $$$ for this exact database app
 

awesome. thanks for sharing. can't wait :)

i only said qt c++ so it would be more portable and sustainable in the future if whoever stepped up was just a mercenary.

Re: bounty $$$ for this exact database app
 

PortaBase is basically this kind of application, and I'm just about done porting it to Maemo (I bought an N900 last week, I'd been working on a Diablo port for my N810 prior to that). The plan is to have a 2.0 release for Fremantle, Diablo, Debian, Mac OS X, and Windows sometime in the next month. I can look into getting it added to extras-devel before then if people want to try it out as is; it's already beta-quality, I've just been going through the UI and fixing things that don't look quite right.

The features are still basically as listed on the PortaBase homepage. Some technical details on the updated code if anybody's interested:

• Qt 4.6 assumed for Fremantle, Qt 4.5+ elsewhere
• Still C++, still GPLv2
• Still using Metakit as the underlying database. I plan to switch to SQLite later, but didn't want to tackle that at the same time as the Qt API upgrade, Mac port, and Maemo ports (it's been taking long enough as is)

Unlike glom, it lets you define and re-define databases on the device. Also supports encrypted files, images and slideshows, calculated fields, etc.

Re: bounty $$$ for this exact database app
 

thanks crashanddie and jmbowman, i guess just wasnt quite patient enough :)

i look forward to these apps

Re: bounty $$$ for this exact database app
 

jmbowman, i have never used portabase but am going to try it out desktop.

i read the documentation and it seems this is so, but i wanted to make sure, namely that the file format created by the different os versions is compatible across those versions. more simply, a portabase created on a desktop version works on a mobile and vice versa?

Re: bounty $$$ for this exact database app
 

Correct, the database files are portable across all supported operating systems. There are minor differences in the UI between platforms in order to behave like a proper native application in each environment, but the data files are universal. Some data in the file that's dependent on the screen resolution (like column display widths) is stored twice: one setting for full-size desktop screens and another one for portable device screens, so you don't need to resize everything to see the data comfortably when moving the file back and forth between systems; you see the display as you last configured it for a screen of that size.

The file format actually hasn't changed at all for the 2.0 release. I even put off implementing a few features, because I want to make sure that anybody still using the Zaurus version of PortaBase (which isn't getting updated) gets the option of using an updated desktop version which is still compatible with their PDAs. A future PortaBase release will increment the file format version again in order to add new features, at which point the older Zaurus version won't be able to open files created or modified by that new release.

Re: bounty $$$ for this exact database app
 

PortaBase is now available in extras-devel. I don't think it'll install on the N900 until PR1.2 is released, but the binary is there and ready for when it happens. The Diablo version is in decent working shape, I've been using it on my N810 for about a week now. There's now a separate thread for PortaBase discussion.