• AVR Freaks

A small database for PIC32

Author
Deenayd
Super Member
  • Total Posts : 905
  • Reward points : 0
  • Joined: 2004/09/08 06:15:13
  • Location: Poland
  • Status: offline
2010/01/08 07:05:34 (permalink)
0

A small database for PIC32

Is anybody aware of small database engine, that could work on PIC32s?

Obviously it would need a real file system (transactional: in case of power failure an interrupted 'write' is either completly persisted or completly ignored), but we already have this problem solved.

I have taken a look at a few solutions, many can fit in FLASH, but unfortunatelly none in SRAM.

Slawek Piotrowski
Rejestracja Czasu Pracy Ewidencja Czasu Pracy
#1

5 Replies Related Threads

    amammes
    Starting Member
    • Total Posts : 54
    • Reward points : 0
    • Joined: 2009/02/18 04:29:46
    • Location: 0
    • Status: offline
    RE: A small database for PIC32 2010/01/08 13:05:27 (permalink)
    0
    SQLite is an embedded ACID database that could be ported to a PIC32. You would have to create your own read() write() open() sync() etc calls to get it to work. It also has an option to use memory database.
    #2
    rowebots
    Junior Member
    • Total Posts : 93
    • Reward points : 0
    • Joined: 2008/11/27 09:11:38
    • Location: 0
    • Status: offline
    RE: A small database for PIC32 2010/01/08 14:33:22 (permalink)
    0
    I would agree that sqlite is the logical choice.  It would run easily on top of Unison with minimal porting effort given the POSIX and Linux compatibility, but it sounds like you have this covered.


    Regards ... Kim

    http://rowebots.com
    #3
    Deenayd
    Super Member
    • Total Posts : 905
    • Reward points : 0
    • Joined: 2004/09/08 06:15:13
    • Location: Poland
    • Status: offline
    RE: A small database for PIC32 2010/01/11 07:02:59 (permalink)
    0
    Thanks for the hint. I will look into SQLite.

    Slawek Piotrowski
    Rejestracja Czasu Pracy Ewidencja Czasu Pracy
    #4
    rowebots
    Junior Member
    • Total Posts : 93
    • Reward points : 0
    • Joined: 2008/11/27 09:11:38
    • Location: 0
    • Status: offline
    RE: A small database for PIC32 2010/01/11 09:19:36 (permalink)
    0
    If others are interested, we might to a port and provide it on the open source version of Unison using fsys, the extent based file system. 

    Comments?

    Regards ... Kim

    http://rowebots.com
    #5
    amammes
    Starting Member
    • Total Posts : 54
    • Reward points : 0
    • Joined: 2009/02/18 04:29:46
    • Location: 0
    • Status: offline
    RE: A small database for PIC32 2010/01/13 20:44:56 (permalink)
    0
    ORIGINAL: rowebots

    If others are interested, we might to a port and provide it on the open source version of Unison using fsys, the extent based file system. 

    Comments?


    Sounds like a good idea, as long as you are willing to keep up with the relatively frequent SQLite releases. Otherwise you might be buying yourself a big problem if the codebase gets outdated quickly.
    #6
    Jump to:
    © 2019 APG vNext Commercial Version 4.5