Author Topic: Good database for c750  (Read 11215 times)

markbedish

  • Jr. Member
  • **
  • Posts: 56
    • View Profile
    • http://
Good database for c750
« on: April 27, 2004, 08:03:20 am »
Hi,

Anyone have good ideas for a decent database on the sharp rom?
I have tried tkccard but it is not very sophisticated., e.g. only sorts on 1 column, slow with import/export etc. I have mysql loaded but want something with a decent front end.

Is this the trigger I need to jump onto Cacko qt or pdaxrom? I would love to but as a newbie, dont want to brick the 750 and would also like to return to the sharp, just in case ...  Any UK users willing to share their experiences?

Thanks for a great forum!

Mark
(Surrey,UK)
3200 from conics.net (switched from sharp to pdaxii13)

grey_moon

  • Full Member
  • ***
  • Posts: 100
    • View Profile
Good database for c750
« Reply #1 on: April 27, 2004, 08:07:25 am »
decent frontend? how about phpmyadmin? has anyone tried that?
SL_5600 with Sharp ROM 1.32 - Windows XP Pro
AmbiCom 802.11b CF WL1100C, Pretec CompactBT Bluetooth CF, Hagiwara 256MB SD Card
Expansys Black Chairmans Case, ShirtPocket Battery Extender, ShirtPocket Retractable USB Sync/Charger

terminate

  • Newbie
  • *
  • Posts: 26
    • View Profile
    • http://
Good database for c750
« Reply #2 on: April 27, 2004, 08:37:19 am »
i used both mysql and sqlite on my sl5500, you can get a nice qt frontend for sqlite, don\'t remember the name

jp40

  • Newbie
  • *
  • Posts: 11
    • View Profile
Good database for c750
« Reply #3 on: April 27, 2004, 10:23:18 am »
I have used Mysql 4.0.16 and phpMyAdmin
Both seem to work alright.

I have a full version of tkcRekall but this has some problems on the C760.

It would be ideal if it worked properly with the latest python on the c760

 :twisted:

jmbowman

  • Newbie
  • *
  • Posts: 22
    • View Profile
Good database for c750
« Reply #4 on: April 27, 2004, 11:46:24 am »
Have you tried PortaBase?  (Disclaimer: I wrote it.)  It\'s still only a 1-table database, but it does support multiple-column sorting and there\'s a desktop version of it for both Windows and Linux, so you can do import/export operations there if the Zaurus version isn\'t fast enough for you.  It isn\'t a substitute for a full SQL database, but it\'s fairly easy to use and full-featured enough to be useful for a pretty broad variety of tasks.

Jeremy

markbedish

  • Jr. Member
  • **
  • Posts: 56
    • View Profile
    • http://
Good database for c750
« Reply #5 on: April 27, 2004, 04:23:50 pm »
I tried to install Portabase but it gave me a \'sorry something went wrong\' message. The application appeared in my app tab though but having tried it am not sure it is working, as it wont see any text files for import.


I might take a look at phpmyadmin though as I did get mysql working!

Thanks,

Mark
3200 from conics.net (switched from sharp to pdaxii13)

jmbowman

  • Newbie
  • *
  • Posts: 22
    • View Profile
Good database for c750
« Reply #6 on: April 27, 2004, 06:07:15 pm »
Were you low on space when you installed PortaBase?  Version 1.9 uses about 1.75 MB.  Another possibility is that another application installer did something weird to /opt/QtPalmtop/etc/mime.types, which is updated by the post-installation script; after installation it should contain entries for application/portabase (pob) and text/x-csv (csv).  Those are the only possible reasons that come to mind for the installer error message...

Note that PortaBase only considers files with a \".csv\" extension as valid CSV files, so files with \".txt\" or such won\'t be listed.  Also, you need to create a new file and define its format before you can import data from a CSV file; hence it isn\'t an option when choosing \"Import\" from the file selector menu (XML and MobileDB files define their data types, so they can be imported directly as new PortaBase files).  Instead you need to create or open a file and choose the \"Import\" menu item shown in the data viewer screen.

Unfortunately, CSV import in PortaBase is kind of like the Debian installer; it hasn\'t been improved much since the first version because I only had to deal with it when first migrating my data, but it scares some people off because it\'s the first part of the program they use.  I plan to add a new CSV import dialog in version 2.0 that makes this a little more user-friendly, so you can define the format for the new file while looking at data from the CSV file to be imported, similar to the CSV import dialogs in common spreadsheet applications.

Hope this helps,

Jeremy

Murahachibu

  • Newbie
  • *
  • Posts: 15
    • View Profile
    • http://
Good database for c750
« Reply #7 on: April 28, 2004, 01:53:54 am »
Jeremy,

I love portabase. Thanks!

Quick question: Are there any plans in the works to enable both screen views possible on the 7XX units?

That\'s the only real thing lacking for me right now.

Cheers.

kenroy

  • Newbie
  • *
  • Posts: 19
    • View Profile
    • http://
Good database for c750
« Reply #8 on: April 28, 2004, 02:19:25 am »
Quote
I tried to install Portabase but it gave me a \'sorry something went wrong\' message. The application appeared in my app tab though but having tried it am not sure it is working, as it wont see any text files for import.

The same thing happens when I try to install PortaBase on my SL-C860 and I definitely had enough internal memory available.  The application does seem to work though.
SL-A300 | Sharp ROM 1.50 J | Panasonic 256MB SD
-----------------------------------------------------------
SL-C860 | Sharp ROM 1.40 JP | Panasonic 1GB Pro High Speed SD | Buffalo WLI-CF-S11G | KWINS PHS CF card

PowerZ

  • Jr. Member
  • **
  • Posts: 55
    • View Profile
    • http://
Good database for c750
« Reply #9 on: April 28, 2004, 06:49:42 am »
Jeremy --

Portabase is great.  I have used it for both my own DBs as well as some existing reference Palm DBs.  The import enhancements sound great.  Keep up the excellent work.
C-750 - Cacko ROM version 1.21b - Lexar 256MB SD card - Kingston 1 GB CF Card

SL - 5500 - Sharp ROM version 3.13 - SanDisk 128 Mb SD card - Mr. Flash 128 MB CF Card

Miami_Bob

  • Sr. Member
  • ****
  • Posts: 483
    • View Profile
Good database for c750
« Reply #10 on: April 28, 2004, 08:38:55 am »
Jeremy

A repository of templates & example databases would be GREATLY appreciated by us older, less creative types <G>!


THANKS!


Bob W
Miami FL
Bob W - Miami FL
--------------------
"The legs of the duck are short and
 cannot be lengthened without distress
 to the duck.

The legs of the crane are long and
 cannot be shortened without distress
 to the crane."

Chuang-tzu

--------------------
C860 main - Sharp 1.40 JP ROM
Language conversion by hand

alts: Cacko 1.22 / OZ 3.5.1 / pdaXrom
512Mb SanDisk SD (x2) / 512Mb SanDisk CF (x2)
Lexar 1Gb CF / AmbiCom WL1100C-CF 802.11b WiFi

Out of Hp200LX, from HP100LX, via HP95LX
--------------------
Desktop MegaTower c/ twin DataPort HD racks;
12 removable HDs with multi OSs - no waiting.

--------------------

bluedevils

  • Hero Member
  • *****
  • Posts: 1284
    • View Profile
    • http://
Good database for c750
« Reply #11 on: April 28, 2004, 09:31:55 am »
I have no problems installing portabase on a tkcrom 760
I'm now an iphone user and use my zaurii as serial terminals, perl and shell scripting and when I need 640x480 screens

sl-c3100/pda cacko 1.23 | sl-6000l/needs battery | sl-c760/server pdaxrom rc12 | Former sl-5500/tkcrom owner (sister's birthday gift)

jmbowman

  • Newbie
  • *
  • Posts: 22
    • View Profile
Good database for c750
« Reply #12 on: April 28, 2004, 04:05:11 pm »
Murahachibu: If you mean landscape and portrait, you just need to tap and hold the application icon and uncheck \"Display with magnified screen\" in the resulting dialog; this is standard for all applications that also run on the SL-5x00 models.  Otherwise, I\'m not sure what you mean...

kenroy (and others): Did you also get this message when installing version 1.8?  If not, I suspect it\'s somehow related to a change I made in the post-installation script; I only did that in order to handle cases where a previous application installer didn\'t end the mime.types file correctly, so if it\'s causing this problem for enough people I should probably just change it back.  I can put together a package using the old script if somebody wants to test it and see if that eliminates the error message.

Miami_Bob: I\'d like to see a repository of files and file templates also, but don\'t really have time to set one up and maintain it (at least without slowing down the pace of development on the application itself); this has been on the \"Ways to Contribute\" page for quite a while, but no volunteers so far.

PowerZ

  • Jr. Member
  • **
  • Posts: 55
    • View Profile
    • http://
Good database for c750
« Reply #13 on: April 28, 2004, 09:55:26 pm »
jmbowman wrote:
Quote
I\'d like to see a repository of files and file templates also, but don\'t really have time to set one up and maintain it (at least without slowing down the pace of development on the application itself); this has been on the \"Ways to Contribute\" page for quite a while, but no volunteers so far.

Jeremy - Why not allow anyone to post the templates as some PocketPC databases do?

Also, as a suggestion (probably not the best place to post this, but...) what about a Windows Mobile 2003 port?  There are a few (and very few) things available for that OS that force me into a dual OS mode and having data available with both PDAs would be awesome.
C-750 - Cacko ROM version 1.21b - Lexar 256MB SD card - Kingston 1 GB CF Card

SL - 5500 - Sharp ROM version 3.13 - SanDisk 128 Mb SD card - Mr. Flash 128 MB CF Card

mikew

  • Full Member
  • ***
  • Posts: 193
    • View Profile
Good database for c750
« Reply #14 on: April 29, 2004, 03:37:17 am »
Murahachibu: You should find that Portabase will automaticall move between landscape & portrait modes when you swivel the screen on the clam shell models, it works on my C760.

Mike
C3200, C760 Cacko 1.23 ROM, 1gb SD, 1gb CF, WiFi, Imate Jasjar & Psion Netbook