Re: Delphi's for CE?
- From: Robin <Robin@.com>
- Date: Tue, 21 Mar 2006 09:24:16 +1100
Bryce K. Nielsen wrote:
What have you chosen? One project I'm working on uses Firebird as an embedded DB for a desktop application. We're looking at the possibilities of making a PDA version of the application, so we're starting to research how to do this. One choice is going to be language to program in, and the other will be database to store data with. We're also considering having either a PDA add-on that synchs with the desktop version, or a PDA stand-alone without desktop version.
Hi Bryce,
I have not chosen one, no. A little (un-nameable) birdy tells me to be patient in this area and I might see something from a soon-to-be spun out company ;-p
For the moment though, life must go on. So I have, for the first time ever created my application with proper classes and layers :-) So only the data connection class knows HOW the data is retrieved. Thus, I can change it when ever I like. (Sure, this is probably normal to everyone else here but a first for me!)
I started with db4o. Which I loved. It is an 'object' database. I am used to regular databases like Firebird, MSSQL etc so the easiest way to get used to it for me was to treat it like a searchable object stack. I am only going to need 3 tables on the mobile device so it suites me fine. However, It is only free if your application is to. (Booooooo!). As far as ease of use goes, it rocks. Anybody, even I, can use that one within 2 minutes of downloading it (and that includes mentally translating the C# example code into Delphi)
I tried SQLite. Well, sort of. I have to admit I couldn't get it to work. After an hour of cursing, I tossed it. Very likely it was something I was doing wrong but at the end of the day I am a hobbiest and it ate up an hour of time I didn't have to start with. It was late, I got angry and decided my nice new Dell notebook didn't deserve my frustration :-). I might look into it again when I have a moment.
My latest experiment was creating a mongrel database class of my own using XML to load/save to file, and loading search criterion into datatable(s) at run time. I didn't want the whole table because of memory concerns, and XML is slooooow, so I only retrieved what I needed to search. Plan was to then only fetch the whole record on individual demand. It seems to work, but isn't very impressive. I felt better for doing it though. (My data did not need to be encrypted or secure so being plain text in the XML was not an issue)
I have looked at some others, but have not found any thing I like AND is free. If I were paying, I would have chosen db4o by now I think. They have .NET, Java and .NET CF versions. Along with a replication server which may be handy.
I have had to put it down for a couple of days to do other things so I am very interested I hearing what others think and have tried.
Bring on Firebird CE :-)
--
Robin.
"He who treats the database as a flat-file repository of data is doomed to burn in Hell. It's true, I asked." - Dratz
.
- References:
- Delphi's for CE?
- From: Bryce K. Nielsen
- Re: Delphi's for CE?
- From: Robin
- Re: Delphi's for CE?
- From: Bryce K. Nielsen
- Delphi's for CE?
- Prev by Date: Re: Go, software activation, go!
- Next by Date: Re: Go, software activation, go!
- Previous by thread: Re: Delphi's for CE?
- Next by thread: Re: Delphi's for CE?
- Index(es):
Relevant Pages
|
