Compact Framework Database Suggestions

[Dustman]

I'm about to start developing some applications for HP IPAQs running PPC2003. I've never messed with the .net compact framework so I'd like to hear some suggestions. The tools are for in house stuff so I'll actually be buying the PDAs that work best with the new software I write.. in other words, compatability really isn't an issue right now.

Does anybody here have any experience with DBs on PPC2003? We worked with some a few years back on PPC2002 but they were so slow it took forever to process large queries.

The basic flow of my app will be downloading a new db everyday, modify and add records, and uploading only the changes at the end of the day (or periodically when connected vi WiFi). I've done small scale stuff like this just using data tables and xml on the pc but I don't know how well that will work on the ppc.. I'm afraid the filesize of the xml files will be too much as compared to just using a db of some sort.

I'm not a big fan of mdb files but thats what I've used in the past on our tablet pcs. Is that still an option for ppc?

Thanks in advance everybody.

-Dustin
Rom 8:28

 

[ThatRickGuy]

your primary concern is likely going to be size. I'm not sure which model you are looking at, I'm actually researching a similar project myself and storage space is definately looking like an issue. Luckily in my case, it's a client/server app so I can off load the data storage to the server. but for any sizable amount of data, XML will quickly bloat and take too much HD space. I'm not sure how MySQL or other databases perform on pocket pcs, but I would recommend against Access. And if all else fails, a flat file would be a highly compactable solution.

-Rick

VB.Net Forum forum796 forum855 ASP.NET Forum
I believe in killer coding ninja monkeys.

 

[Dustman]

Yah.. thats what I've been worrying about. I'm going to have quite a bit of removable starage because there will be pictures involved.. however I don't know about speed on the cards. This will be a client/server app in a way. We have guys in the field that will be using the ap for data input. As soon as they are in range of a tower it will connect and upload changes. I may be uploading 1 record or several thousand.

As far as the transactions between these clients and the master, I'll probably want to use xml.

-Dustin
Rom 8:28

 

[chrissie1]

there's something like sql-server ce. no idea how it compares. Storage is only an isue if you don't have money. Buy the hp 4700hx and plug a microdrive in it (4gb) is affordable and 20gb is possible) and a small 1gb sd for the minor stuff and it has high resolution vga screen.

Mind you PPC2003 is still highly unstable.

BTW it can also be used as an MP3 player and remote control. A it's fun.

Christiaan Baes
Belgium

I just like this --> [Wiggle] [Wiggle]

 

[Dustman]

Just an interesting note.. I've been looking through the mysql forums and several people have been looking for a way to run mysql on a ppc. So far nobody has a solution but I'm hoping they will.

I did see some people talking about a way to embed the mysql server into individual projects.. I'm curious if that could actually be done with the .net compact framework.

-Dustin
Rom 8:28