1. Forum
  2. Usenet
  3. COMP.OS.OS2.PROGRAMMER.MI

  • Sqlite question

    From Mat Nieuwenhoven@21:1/5 to All on Mon Nov 23 10:42:28 2015
    Hi,

    Over many years I've kept trace of thing-to-do (both professional and
    private) using various approaches, like project planners, spreadsheets,
    to-do lists, helpdesk-type programs, and more. None really does what I
    want, or has all required functionality, so I'm thinking of building my
    own. It must be a native OS/2 executable, absolutely not broser based.
    I thought to base it on sqlite, so at least the storage engine is a
    no-brainer. Multi-user access is not required.
    Hobbes gives as last sqlite version 3,6,12, although there is a qt base
    sqlite browser which has 3.7.8 built-in. Are there any later ones?

    Any suggestions on what to use as GUI front end with this? Or any other suggestions?

    Mat Nieuwenhoven

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Dave Yeo@21:1/5 to Mat Nieuwenhoven on Mon Nov 23 08:00:07 2015
    Mat Nieuwenhoven wrote:
    Hi,

    Over many years I've kept trace of thing-to-do (both professional and private) using various approaches, like project planners, spreadsheets,
    to-do lists, helpdesk-type programs, and more. None really does what I
    want, or has all required functionality, so I'm thinking of building my
    own. It must be a native OS/2 executable, absolutely not broser based.
    I thought to base it on sqlite, so at least the storage engine is a no-brainer. Multi-user access is not required.
    Hobbes gives as last sqlite version 3,6,12, although there is a qt base sqlite browser which has 3.7.8 built-in. Are there any later ones?

    OS/2 support was removed by version 3.7.14, the newest included with FF
    38 is 3.8.9 which has had the OS/2 parts re-added by Bitwise. As Mozilla doesn't patch the sources besides the makefile, this source could be
    used, (it's under db/) or read the sqlite3 changelog for the latest with official support. It was a fairly easy build with the configure and make
    route.


    Any suggestions on what to use as GUI front end with this? Or any other suggestions?


    The QT based sqlite browser is the best as far as I know.
    Dave

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Mat Nieuwenhoven@21:1/5 to Dave Yeo on Tue Nov 24 07:43:30 2015
    On Mon, 23 Nov 2015 08:00:07 -0800, Dave Yeo wrote:

    Mat Nieuwenhoven wrote:
    Hi,

    Over many years I've kept trace of thing-to-do (both professional and
    private) using various approaches, like project planners, spreadsheets,
    to-do lists, helpdesk-type programs, and more. None really does what I
    want, or has all required functionality, so I'm thinking of building my
    own. It must be a native OS/2 executable, absolutely not broser based.
    I thought to base it on sqlite, so at least the storage engine is a
    no-brainer. Multi-user access is not required.
    Hobbes gives as last sqlite version 3,6,12, although there is a qt base
    sqlite browser which has 3.7.8 built-in. Are there any later ones?

    OS/2 support was removed by version 3.7.14, the newest included with FF
    38 is 3.8.9 which has had the OS/2 parts re-added by Bitwise. As Mozilla :>doesn't patch the sources besides the makefile, this source could be
    used, (it's under db/) or read the sqlite3 changelog for the latest with :>official support. It was a fairly easy build with the configure and make :>route.


    Any suggestions on what to use as GUI front end with this? Or any other
    suggestions?


    The QT based sqlite browser is the best as far as I know.

    Thanks, I'll look at it.

    Mat Nieuwenhoven

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)