Data base on the iPhone

Welcome to our Community
Wanting to join the rest of our members? Feel free to sign up today.
Sign up

wripps

New Member
Jun 9, 2007
1
0
0
#1
I am an old palm user, and an old Apple user. I have used database software on both platforms. With Appleworks on the Apple II and the Mac. HanDbase on the Palm. I would really like to do database applications on the iPhone. Has anyone heard how to do that. Has anyone heard if Appleworks will be ported to the iPhone. That would be great.
 

Guest 2

New Member
Jun 23, 2007
2
0
1
#3
Database applications

I am wondering this too. Apple says you can view Excel and Word email attachments. Will we be able to compose in Excel and Word? That would make this phone complete for me - I'd want to have access to work folders. I have a feeling this will not be the case...


I am an old palm user, and an old Apple user. I have used database software on both platforms. With Appleworks on the Apple II and the Mac. HanDbase on the Palm. I would really like to do database applications on the iPhone. Has anyone heard how to do that. Has anyone heard if Appleworks will be ported to the iPhone. That would be great.
 

Kabeyun

Member
Silver
Jan 10, 2007
665
0
16
Northeast US
#4
I'm also really hoping for DB creation & editing capability. So far, not possible. I'm getting rid of my Treo, so I picked up a cheap Zire ($35, eBay) for critical DBs until there's something available for iPhone.

-K
 

Spin This!

New Member
Silver
May 4, 2007
504
0
0
#6
yeh filemaker would be an interesting solution. I haven't used it myself... does it have a web interface where you can edit records?

or roll your own web client to hook into any db you want on the server-side.
 

ebob

New Member
Jun 26, 2007
7
0
0
#7
You can either use Instant Web Publishing, which mimics the GUI of the database you build in FileMaker -- it works pretty well, there are a few drawbacks to it, but it is, well, instant. There is also custom web publishing, and you can use PHP or XML/XLST. If you want to roll your own, i.e., PHP and MySQL, that certainly will work. Just design for the screen size.
 

asdiphone

New Member
Jun 17, 2007
13
0
0
#8
I am an old palm user, and an old Apple user. I have used database software on both platforms. With Appleworks on the Apple II and the Mac. HanDbase on the Palm. I would really like to do database applications on the iPhone. Has anyone heard how to do that. Has anyone heard if Appleworks will be ported to the iPhone. That would be great.
take a look at zoho.com

they have a host of products that work on the iPhone...

spreadsheet, word processor, powerpoint, and a database.

you can use zoho on the computer and mini.zoho.com which is optimized for the iPhone.
 
Jul 22, 2008
5
0
0
#9
DB for iPhone

I run Filemaker 2.0 on my HTC Tilt (even use to on my SX66. I use it for all of my client project files, photofiles and project management. Lets see Filemaker's Apple's own product and yet it does not run native on the most powerful PDA device on the market.

I'm still so blown away that the iPhone is getting all these raves when it's really an over glorified phone/mp3 player. I had one for two weeks (iPhone ver. 1.0) I love its OS though some hurdles I'd like to see solved:

- sorting of contact by company names (sorry I don't remember everyone's name with vendors and companies I deal with. Like to sort by company, last name please.
- finally 2.0 solves the multiple deletion of emails. one good fix.
- a fully programmable relational database. can you say FILEMAKER
- integration of the contact, calendar, todo/task list. Take a look at Adgendus (www.iambic.com). a sweet shell that runs over the OS of WinMobile
- applications that can run native, NOT web based. I really don't want my phone bill higher than it is. Oh yeah... they made a deal with AT&T... hummm sounds like something done on the 'cross-roads'.
- Flash? Uh, does anyone know...does iPh 2.0 support Flash finally?
- SD memory micro! Sure would be nice to have a chip to add memory or maybe files I want to make portable (not have to sync with the memory hog iTunes.
- how about a very small, low memory profile sync-ing app. Something that can tie into things you want to sync. Like apps and data.
- Works. Would be so awesome to be able to work on an Excel sheet or Word doc. from the iPhone. That big screen, the zoom-ability. It's so perfect and a QERTY keyboard.
-replaceable battery so, when my phone is low I can swap out the battery for a fully charged one and recharge the first.

The iPhone has the most powerful processor in any PDA in the world, the biggest memory HD of any device, the cleanest and fastest OS. Why can't it do something real for me, a computer user that also would like to have a really portable computer....which the iPhone so easily can be and be native.

BTW- traded in the iPhone 1.0 back to the HTC Tilt, until someone can show me the iPhone can really do something.

Love the device as a unit though... very cool looking.
 

Kabeyun

Member
Silver
Jan 10, 2007
665
0
16
Northeast US
#10
The iPhone has the most powerful processor in any PDA in the world, the biggest memory HD of any device, the cleanest and fastest OS. Why can't it do something real for me, a computer user that also would like to have a really portable computer....which the iPhone so easily can be and be native.
Give it time, my friend. The personal user was Apple's initial target demographic, not the businesss user. With FW 2.0 and full Exchange server support, Apple has taken a big step in courting industry (in fact, Apple had an extensive industry deployment pilot program before the release of the new firmware). Additional steps will follow. Developers will release DB apps. Microsoft will release an Office for iPhone. The platform is a true platform now and will evolve quickly now that Apple knows it has a hit on its hands. I agree the UI does need some improvement (better sorting, cut/copy/paste, undo, etc.) and that's coming. Regarding hardware, things like user-swappable battery and flash memory may be useful for some, but there are also good reasons why they shied away from them.

- applications that can run native, NOT web based. I really don't want my phone bill higher than it is. Oh yeah... they made a deal with AT&T... hummm sounds like something done on the 'cross-roads'.
You're aware of the App Store? >500 native apps and counting...

Welcome to EIC.com! :cool:

-K
 
Jul 22, 2008
5
0
0
#11
Yeah, found out it was not for businesss owners the moment I had to switch my AT&T account from my businesss to a personal account. My CPA was not too happy with that and paying for the cell ph. account with the businesss check was an interesting one for my taxes this last year. Another reason why I had to switch back.

I do love what seems to be coming but, it always seems to be coming. Don't get me wrong... I'm almost a converter but there gotta be a few changes before I commit this time.

Thanks for the welcome!

-jeff

Give it time, my friend. The personal user was Apple's initial target demographic, not the businesss user.

You're aware of the App Store? >500 native apps and counting...

Welcome to EIC.com! :cool:

-K
 
Jul 25, 2008
14
0
0
Ardooie, Belgium
#12
Jeff you are aware that FileMaker has discontinued FMP Mobile alltogether. I take it that is what you are using now on your HTC.

Personally discontuining FMP Mobile and focusing on Web Publushing DB's, i think was one of the worst decisions FileMaker ever made.


Really hope some developer sees this 'hole' and jumps in to make a DB application for the iPhone using SQLite (which is the standard DB Engine on iPhone) that syncs with FileMaker DB's
 

wildor

New Member
Nov 19, 2007
16
3
3
#13
I emailed Dataviz about a month age. They make Smartlist togo, a very powereful database much like Microsoft's Access. They said that they were interested in looking at the iPhone SDK to port their software to the iPhone. I haven't heard anything from them yet. I will try to get an updated status report tonight. I really miss not having a DB on the iPhone.

http://www.dataviz.com/products/index.html
 
Jul 22, 2008
5
0
0
#14
Dataviz is nice stuff. I use that myself too on my HTC and my old Sony Clie (yeah, have that too). If they made something that would be sweet. But, I'd like to not have to have 4 DB's for my data. A Filemaker hookup sure would be awesome. Did not know that FMmobile was discontinued. That's a bummer.

Though the smartest thing would be some developer doing something within the SQlite... that would be native and if they built a sync to FMpro oh my I'd buy 3 right off the start... one for each of my staff.

Oh yeah....that's my other iPhone gripe...what's up with it having to be a personal phone account? (must be the iTunes lic. stuff). When I did buy the first iPhone my 20 yr long AT&T Business account (think Cell One...Cingular....AT&T. I was customer #13 of Cellular One) had been switched to a Personal account. Which I'm not back hasseling to a biz account. IT's a businesss mess for accounting and legal stuff in a Corp.

The iPhone's got the guts, power and ability to be the most kick-butt porable computer device, and a personal fun toy too.
 
Jul 25, 2008
14
0
0
Ardooie, Belgium
#15
Okay, just subscribed to the HanDBase Yahoo group, and surprise (or not, see below) they are working on a version of HanDBase for iPhone.

Looks like a lot of the long-time developers for Palm, Windows Mobile, ... will also start to develop for iPhone. Among other iambic, WebIS, Mobipocket (somewhere at the end of this year, these guys are utterly slow) ... and two other DB producers DataViz (SmartList ToGo) and Ilium Software (ListPro) so DDH Software could stay behind.


Yes my friends these are exciting times :laugh2:

If only my iPhone would arrive now ... ordered July 11th and still nothing to show for it
 
Jul 22, 2008
5
0
0
#16
That's great news to hear. Hmmm... I think I'll wait till: a) the huge rush on the iPhone is over, b) there's a way to get it to be on my businesss account not a personal account (need to hassle AT&T on that one).

Though, I'm happy to hear Dataviz is getting involved they had a great hookup to FMpro on the Palm that worked pretty slick. Plus maybe all my DB's I have on my Clie will port over and I'll only have to have one device. ;-)

The phone really should be able to run my live.... I have to listen to it...why can't it help me. :laugh2:

If/when you find out more keep me posted I'd love to hear feedback on it.
-jeff
 

wildor

New Member
Nov 19, 2007
16
3
3
#17
Dataviz Smartlist togo

I received an e-mail from Dataviz stating that are going to port Documents togo to iPhone, but at this time no plans to port Smartlist togo. Bummer.
 
Jul 22, 2008
5
0
0
#18
That's kind of a bummer. Amazing the one app/tool that's not available for this large storage, high-power device is a DB...

More I think on it... sure would be awesome if some developer would work off of the SQlite or some migratable DB utilizing it. Someone's gotta be thinking in the same realm we all are.

This is where I wish I was geek enough to know how to build something like this. :laugh2:
 
Jul 25, 2008
14
0
0
Ardooie, Belgium
#19
Not exactly a FileMaker hookup in the sense that everything's possible, but it's a first step.

Some Swedish developer has developed CSV Touch and what it does is actually very simple, it converts a CSV file in a searchable and sortable DB for the iPhone. So you could export a FileMaker DB (or any DB for that matter) to a CSV file and then import it to the iPhone for offline reference.

Sometimes the simplest ideas are the best :cool:
 
Aug 12, 2008
1
0
0
#20
FileMaker DB on iPhone

Try the new FMTouch to work with your FileMaker databases on your iPhone:
http://fmtouch.com/

It's for serious businesss users and priced accordingly ($69) so it's not for lightweights who whine if an app isn't under $1.99. Also requires advanced versions of FM8 or 9.