hurst75

Hello All,

Sorry if this is the wrong forum (i'm sure the thread will be moved if it is!)

I am seriously considering getting the htc hero (g2 touch), but everything hinges on the availability of a mobile database app, such as Visual CE (which I currently use on my WM phone) or Handbase. Basically a customisable form-based data collection app which can be sync'ed with a desktop database.

Does anyone know of such an app?

Many thanks!

PS one of the shortfalls of Android from a marketing perspective is that there is no definitive way to view all available applications - Android Market is limited when accessed via the web.

Last edited by hurst75; August 14th, 2009 at 04:20 AM. Reason: inaccurate/spelling

hurst75

I'll assume thats a "no" then??

OolonColuphid

Do a search here: Cyrket - Android Market Browser

hurst75

I have dude. I've trawled the net and this forum is my last hope. I think I'll either have to wait until somethingis developed and persevere with windows mobile which is sh*te or learn Java and make it myself!

BoyGenius

hey hurs, i hear you. i'm in the same boat - salivating about the Hero but really need a database prog. Still using SLTG on my Palm Treo650!! Fortunately I suppose, the Hero hasn't been released in Aust yet, so I'll have to wait a little longer. If you can teach yourself Java, I'll buy the app of you!

Motjida

All,

Have you tried out AndroidDB?

/Mot

hurst75

Hi Mot,

Yep had a look at that but I don't think it offers anything like the functionality that I would require. It's good to see that people out there are trying tho. I emailed the guys at Handbase recently, which offers a perfect solution for many mobile platforms including the iphone. They're not even considering starting on the software "due to lack of demand and technical roadblocks due to development environments".

I fear that its going to take a lot more exposure(=money) from Google before Android can compete against the heavyweights out there.

Still loving the G2 tho!

Last edited by hurst75; August 28th, 2009 at 03:38 PM.

Tommy2Tone

Geez, I knew I wouldnt be the only one wanting a database for my phone.
I am looking at a company called "Alpha Five" It is a object oriented DB that saves to many formats including SQL and google android. Dont get your pants in a rise because it may be BS but it is trial for 30 days, I think and downloadable from here. Database Software, Database Programs, Database Manager, Rapid Web Application Development Database Solutions Online Web interface Design Desktop Applications Good Luck, I know you are wishing me the same. If I am successful it will be available to public.

imabug

I could use a mobile DB app on android too. I still use ThinkDB (now SmartList To Go) on my T3 and have several databases that I use to keep track of things. Haven't seen anything similar yet for Android.

Tommy2Tone

to imabug or ?.

I just finished reading an article expressing a piece of software that allows us to make our own apps using a point and click method similar to Hypercard for the mac. this was supposed to be for android based phones. If I find the particulars I will post them here. If you see no post then I was full of sh--. lol.
I am anyway but I will check thru my emails and bookmark.

Johnwt

It is now February, I can't believe that there is not a user configurable database for the Android platform. Any updates or information on a usable DB? I would settle for a flat file DB with as few as 12-15 fields. Any new information? I can't get an Android phone until one is available. Thanks.

Tommy2Tone

John. Sorry I haven't posted any follow up information sooner. I seem to find other things that rate higher on the priority list. I still use my old phone because I haven't been able to find a database for the HTC that I would purchase if the application were available. Think DB is a database for phones but as of yet not available for android based operating systems.

I haven't had time to research a patch to run web os programs on android os systems. Nor, if "think DB" is going to port it over for android phones. I purchased a sony PSP instead as that will handle all my entertainment needs when I fly.

I still have on my "to do" list to find a workable solution. Maybe between the 2 of us we can figure it out. I didn't see much response to this thread but I can't believe we would be the only 2 people to want such an app.

Good luck in your hunting. I will keep involved. Tom.

Johnwt

Tommy@Tone, thanks for the update but obviously disappointed by the news. How can this be with Android now bragging about 15,000 apps and no user config DB? Oh well, I would like to move up but won't until one is available. If I find anything, I will post here, please do the same.

jeffdlb

I'm in the same situation--I don't want to get rid of my PalmOS Centro until a Mobile DB is available elsewhere. I am currently using SmartList To Go. I am surprised this is so difficult given that Android has SQLite under the hood. I don't think WebOS or iPhone have a mobile DB either..

Tommy2Tone

You are farther along than I am. I still use my sprint flip phone with the rubber guard around it. I only agreed with my girlfriend to get a new phone if I could get one with a database so when I buy a new DVD I can check my DB and see if I already have it. Tired of having to take duplicates back. I know that inputting the data will also be tedious so I really don't know what to do.
I will commit to posting any new info here.

Tommy2Tone

just a follow up. That database that I had talked about in my 1st post would have created SQL applications but they needed the host, or creator program to function. It was 25mb I think. I downloaded it and played with it for a week and wasn't impressed. Even if it had a small footprint I don't think I would have used it. Too complicated.

evasua

Memento is a personal database that allows you to store all personal data in one place.
android market: market://search?q=pname:com.luckydroid.droidbase
web: luckydroid.com
try it.

Last edited by evasua; March 6th, 2010 at 08:54 AM.

SimonJudge

I have just completed a generic Database app for Android...
Android Database

Simon Judge

dewalist

No disrespect to SimonJudge, but I would second the vote for Memento. Imports/Exports, backup to SD card, completely customizable with many field types. It would be absolutely perfect if it had backup to the cloud (Google Docs?) and a secure/encrypted option.

lulugirl896

The latest version can sync with Google Docs

__________________
Mobi·gas·mic!
___________________________________________
T-Mobile Treo 600--> Cingular Treo 650--> Cingular 8125--> Imate JasJar--> TMobile SDA--> Cingular Blackjack --> Cingular 8525-->UBiQUiO 503g-->HP iPAQ 910c-->HTC Fuze-->Blackberry Bold --> Blackberry Onyx--> Nexus One

trankster

I downloaded Memento, plus purchased the Pro version unlock code. But, I cannot see how to import .csv nor export. There is no menu, help or manual for the program. Has anyone figured out how to import from other databases (.csv)?

Rotor

Yep, I have. What you need to do is first create a custom library in Memento on your handset. Then add fields that are identical to the fields in the CSV file you are trying to import. Add the CSV file you want to import to the Memento folder on your phone.

Once you've done that open your newly made custom library click 'menu' then 'more' then 'Import and Export' and finally 'Import from CSV'.

Everything should start importing and you should end up with the library populated with all the data you wanted.

Worked for me on my HTC Desire. Highly recommended database app, fully searchable too.

Zoandroid

Hi. I just got a reply from DDH Software saying they are working on HanDBase for Android OS. But until it releases, I need 'something' so I'll have a look at Memento.

WindsorKnight

Has anybody used MobiForms to create a database app for Android?
MobiForms Mobile Application Development Tools, Mobile Forms, Database Synchronisation, Mobile Replication

I want to create a data collection app that lets me download the collected data to a PC or server based database for comparison and analysis. Real time posts back to the main database would be nice, not not required. I have not yet purchased a phone so open to any good solution.

Filemaker http://www.filemaker.com/products/iphone/ and HanDBase DDH Software - HanDBase Sync Exchange for MS Access seem like possible options.

I watched some of the videos on Android app developement and do not want to learn Java to create a database....would like to know java, but to not want to spend the time to learn it.

I know SQL, so using SQLite is not a problem if I can find a good tool for creating the data collection forms.

iamtheapeohyes

memento indeed- just imported a 12 year old psion 5 database (via csv file) and it works very well. "index card" view like the psion had would be nice, but it's the nicest one to use I've had for a decade (which involved handdb etc on palms, Se p800, nokias by the dozen)

zMx-Mic

YES I have MOBIFORMS.... a couple of things... the software does have a few bugs nothing bad...

It does NOT have a compiler which means you have to local install, and the icon will show MOBI whatever....

It is easy to use if you have used any type of database using forms or form to input or view data.

The software manual is ok to get started, showing how to's including barcode printing, CVS file, text lists, and even external DB's

I wish they would add additional functionality to the buttons, but I am still new to it and some of what I am looking for may be there, just haven't found it yet.

OVERALL... at the price knowing what I know now.. specifically the Compiler... I would not purchase, which may only deter me, and if you only want it for personal use it may be a good idea, but I have opted to grab Eclipse, and go that route for now.

I also just got invited to Beta the APP INVENTOR, took a quick look but need more time to view before judgement.

HOPE this helps at least a little.

mopilot

Have you looked at Memento?

beekeeper

I've just added another alternative that might suit for some of you (and probably not for others). "Data Bee" keeps your data as a very simple flat file -- a CSV text file. The advantage to this is that you can exchange it with Excel, MySql, or any other program you like and, via dropbox, even keep it consistently synchronized across platforms.

It also runs *very* fast on even large files. None of the other programs mentioned seem to do very well when given 5,000-50,000 line data files. Data Bee thrives on 'em. You need the $4.99 pro version to be able to edit the files, but you can test out viewing and verify the speed with Data Bee Lite.

I should note that, given the simple CSV format, it does not *yet* support field typing. However, the Pro version remembers meta info about the file, and can eventually be extended to be able to handle at least simple type info. (Numbers and dates certainly. More detailed types, maybe. User response will determine how much development effort goes into extending it.)

curtterp

There is a relational database that is easy to use called HanDBase. The company is DDHsoftware.

You can find it by searching HanDBase in the Android Marketplace.

they also have a desktop program that works on Windows and Mac. This program also sync's with the Android program, backs up your databases and you can also create databases to use on the Android.

The desktop program has a 30 day trial and can be found at http://ddhsoftware.com

They also have a user forum located at http://ddhsoftware.com/forum

The Android program is $9.99.

This database is powerful as a relational database, but you do not need a database degree to make your own databases.

I am not affiliated with DDHSoftware in any way, but I am a long time customer that has used HanDBase on my Palm, Windows Mobile, and now my Droid X.

Last edited by curtterp; June 11th, 2011 at 11:59 PM.

porto.farina

Check the new app named "My Data" by PortoFarina.

This is a very simple database application. It lets you create databases on your SD Card in a folder named My Data. Shortcuts to particular tables in the database can be created in the Android launcher. The application lets you do the following:
- Create/Delete/Rename/Backup databases.
- Create/Delete/Rename tables.
- Create/Delete/Rename columns.
- Create/Delete/Edit rows.
- Create relationships between tables.
- The following types are supported: Text, Integer, Real, Check Box, Date, Time and Phone numbers.
- The application is also localized in French.
- When databases, tables or columns are deleted, a backup of the database is performed automatically. Use any file browser to find the databases and their backups under /mnt/sdcard/My Data.
- The application stores the database using the SQLite file format.
- The application relies heavily on long press gestures to bring up context menus that will let you do some of the above.
- The application manages automatically the primary and foreign keys. So when you are creating your tables, avoid creating primary keys and creating relationships that use them. Use the regular columns for defining relationships. The application even takes care of situations where the linked to values change.
- Referential integrity is implemented by nullyfing the referencers when the referenced rows are deleted.

realtorshannon

I ended up here because I am searching for a database that is base on relationships such as ACT! and MS Access. I preferr ACT! because it works well with MS Outlook. Palm had great software that sync'nd well with ACT but I love my EVO and really need it to work with what I am use to. I am currently looking into buying ACT! 2012...Your input on what you think would be appreciated.

PghDaveHS

Hey all;

Sorry for taking a step back, but I'm not proficient in programming, & I don't pretend to bee a programmer!

That said, I was curious if anyone knew of any e-contractor or moonlighter websites where I can contract someone to build me a database I can input data from my Android tablet & phones, & print from a PC? Basically I am a taxi driver, & I would like to enter my "run" information electronically from the get go via my tablet or phone (instead of writing it out & entering it manually into Access or Excel when I get home), then just print out a copy of a predefined form (as an example, google 'taxi manifest') when I get to the office. The # of fields or questions the tablet or phone app would ask me wouldn't be many (pick up time, odometer @ p/u, p/u location, drop time, odometer @ drop, drop location, # of passengers, & fare, etc), and could be entered quickly via the devices while on the job. My guess is it would be no harder then hiring someone to build me a front & back end Microsoft access database, only via an Android OS app. The info could even reside locally on the devices or on some server space I rent.

Any ideas?
Thanks
Dave
(I apologize if my question is not germain to this thread)

tcat007

Maybe something like this? Cellica Database for Android

Tre Lawrence

One of my most important apps...

__________________
Between Realities

Sideman

I've been wanting a good database app, but haven't really been looking until I saw this thread. I used to program business DBs years ago...VB6, Access, SQL, Excel, and all that stuff.

I just picked up Memento to try it out. If that doesn't cut it, I'll spring for HanDBase (sounds cool). Doesn't seem to be anything else out there...except single purpose apps. I need lots of versatility.

to be continued....

toronado455

Let us know...

I'm using MySQL on the PC. I just wanted to run a MySQL client on my Android device and connect to my server on my LAN.

Last edited by toronado455; February 11th, 2012 at 06:47 PM.