Rocksolid Light

Welcome to novaBBS (click a section below)

mail  files  register  newsreader  groups  login

Message-ID:  

Save energy: Drive a smaller shell.


devel / comp.lang.smalltalk.dolphin / Re: D7-ReStore-ODBC-SQlite

SubjectAuthor
* D7-ReStore-ODBC-SQliteSanjay Minni
`* Re: D7-ReStore-ODBC-SQlitejohn.a...@gmail.com
 `* Re: D7-ReStore-ODBC-SQliteSanjay Minni
  `- Re: D7-ReStore-ODBC-SQliteGlenn Swanlund

1
D7-ReStore-ODBC-SQlite

<35fd1a79-ba51-488f-ab46-fce717157f87n@googlegroups.com>

 copy mid

https://www.novabbs.com/devel/article-flat.php?id=9953&group=comp.lang.smalltalk.dolphin#9953

 copy link   Newsgroups: comp.lang.smalltalk.dolphin
X-Received: by 2002:a05:620a:98c:: with SMTP id x12mr1706305qkx.439.1618462086761;
Wed, 14 Apr 2021 21:48:06 -0700 (PDT)
X-Received: by 2002:a05:6830:2050:: with SMTP id f16mr1168192otp.182.1618462086392;
Wed, 14 Apr 2021 21:48:06 -0700 (PDT)
Path: i2pn2.org!i2pn.org!weretis.net!feeder8.news.weretis.net!proxad.net!feeder1-2.proxad.net!209.85.160.216.MISMATCH!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: comp.lang.smalltalk.dolphin
Date: Wed, 14 Apr 2021 21:48:06 -0700 (PDT)
In-Reply-To: <215be7ce-0759-4fd2-8cd4-9cc06484f302@googlegroups.com>
Injection-Info: google-groups.googlegroups.com; posting-host=106.51.80.86; posting-account=wc7UngoAAABlNyOTTL0vlOzP96a0IeHs
NNTP-Posting-Host: 106.51.80.86
References: <b015aeae-6ee5-492b-963e-fa110901ade2@googlegroups.com>
<176488d8-7d0e-47f7-95c8-b0fa4a2b9c7e@googlegroups.com> <3568c334-522e-49f3-b102-2d1293859ef0@googlegroups.com>
<215be7ce-0759-4fd2-8cd4-9cc06484f302@googlegroups.com>
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <35fd1a79-ba51-488f-ab46-fce717157f87n@googlegroups.com>
Subject: D7-ReStore-ODBC-SQlite
From: sanjay.m...@gmail.com (Sanjay Minni)
Injection-Date: Thu, 15 Apr 2021 04:48:06 +0000
Content-Type: text/plain; charset="UTF-8"
 by: Sanjay Minni - Thu, 15 Apr 2021 04:48 UTC

(Subject Changed)

Hi John (Aspinall),

is it required for D7-ReStore-SQLite to go thru ODBC.

I was looking to reduce any dependency on the local Windows user installation.

Is there a possibility of a single 32 bit package incl SQLite DLL and all drivers without having to depend on any pre-existing files / support from Windows or making any entry in the registry.

(I am using http://www.ch-werner.de/sqliteodbc/)

regards
Sanjay

On Monday, 3 June, 2019 at 1:28:29 pm UTC+5:30, john.a...@gmail.com wrote:
> Hi John - ReStore, my object-relational interface for Dolphin, provides transparent persistency to a relational database and is actively maintained:
>
> https://github.com/rko281/ReStore
>
> Persistency is entirely through normal Smalltalk methods; ReStore takes care of creating and maintaining the database structure so no relational knowledge is needed. Used with SQLite it can provide fast, file-based persistency similar to Omnibase.
>
> Feel free to message me if you'd like more details.
>
> Cheers.
>
> John
> On Monday, June 3, 2019 at 1:05:23 AM UTC+1, john c wrote:
> > On Sunday, June 2, 2019 at 6:58:18 PM UTC-4, Richard Ronteltap wrote:
> > > I think it's removed because of lack of UTF8 support.
> > > https://github.com/dolphinsmalltalk/Dolphin/issues/580
> >
> > thanks.
> >
> > does anyone have a functional equivalent to omnibase?
> >
> > john

Re: D7-ReStore-ODBC-SQlite

<f56290c9-66fd-4130-8422-b8da42bf5bc8n@googlegroups.com>

 copy mid

https://www.novabbs.com/devel/article-flat.php?id=9954&group=comp.lang.smalltalk.dolphin#9954

 copy link   Newsgroups: comp.lang.smalltalk.dolphin
X-Received: by 2002:ad4:576a:: with SMTP id r10mr1959698qvx.12.1618475348137;
Thu, 15 Apr 2021 01:29:08 -0700 (PDT)
X-Received: by 2002:aca:fdc7:: with SMTP id b190mr1769802oii.14.1618475347814;
Thu, 15 Apr 2021 01:29:07 -0700 (PDT)
Path: i2pn2.org!i2pn.org!weretis.net!feeder8.news.weretis.net!proxad.net!feeder1-2.proxad.net!209.85.160.216.MISMATCH!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: comp.lang.smalltalk.dolphin
Date: Thu, 15 Apr 2021 01:29:07 -0700 (PDT)
In-Reply-To: <35fd1a79-ba51-488f-ab46-fce717157f87n@googlegroups.com>
Injection-Info: google-groups.googlegroups.com; posting-host=85.203.71.185; posting-account=OQ6sIwoAAAC1iWrFEUhdmRsgEkeDOgOm
NNTP-Posting-Host: 85.203.71.185
References: <b015aeae-6ee5-492b-963e-fa110901ade2@googlegroups.com>
<176488d8-7d0e-47f7-95c8-b0fa4a2b9c7e@googlegroups.com> <3568c334-522e-49f3-b102-2d1293859ef0@googlegroups.com>
<215be7ce-0759-4fd2-8cd4-9cc06484f302@googlegroups.com> <35fd1a79-ba51-488f-ab46-fce717157f87n@googlegroups.com>
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <f56290c9-66fd-4130-8422-b8da42bf5bc8n@googlegroups.com>
Subject: Re: D7-ReStore-ODBC-SQlite
From: john.asp...@gmail.com (john.a...@gmail.com)
Injection-Date: Thu, 15 Apr 2021 08:29:08 +0000
Content-Type: text/plain; charset="UTF-8"
 by: john.a...@gmail.com - Thu, 15 Apr 2021 08:29 UTC

Hi Sanjay,

ReStore for Dolphin currently only supports database connections via ODBC so you'd need to ensure the SQLite ODBC driver is installed on a target machine.

You can avoid the need to set up an ODBC datasource by specifying a connectString rather than a dsn, for example:

aReStore connectString: 'DRIVER=SQLite3 ODBC Driver;Database=c:\mydb.db'

Porting the SQLite native client from Pharo is on my to-do list so will hopefully happen at some point.

Hope this helps,

John

On Thursday, April 15, 2021 at 5:48:07 AM UTC+1, Sanjay Minni wrote:
> (Subject Changed)
>
> Hi John (Aspinall),
>
> is it required for D7-ReStore-SQLite to go thru ODBC.
>
> I was looking to reduce any dependency on the local Windows user installation.
>
> Is there a possibility of a single 32 bit package incl SQLite DLL and all drivers without having to depend on any pre-existing files / support from Windows or making any entry in the registry.
>
> (I am using http://www.ch-werner.de/sqliteodbc/)
>
> regards
> Sanjay
> On Monday, 3 June, 2019 at 1:28:29 pm UTC+5:30, john.a...@gmail.com wrote:
> > Hi John - ReStore, my object-relational interface for Dolphin, provides transparent persistency to a relational database and is actively maintained:
> >
> > https://github.com/rko281/ReStore
> >
> > Persistency is entirely through normal Smalltalk methods; ReStore takes care of creating and maintaining the database structure so no relational knowledge is needed. Used with SQLite it can provide fast, file-based persistency similar to Omnibase.
> >
> > Feel free to message me if you'd like more details.
> >
> > Cheers.
> >
> > John
> > On Monday, June 3, 2019 at 1:05:23 AM UTC+1, john c wrote:
> > > On Sunday, June 2, 2019 at 6:58:18 PM UTC-4, Richard Ronteltap wrote:
> > > > I think it's removed because of lack of UTF8 support.
> > > > https://github.com/dolphinsmalltalk/Dolphin/issues/580
> > >
> > > thanks.
> > >
> > > does anyone have a functional equivalent to omnibase?
> > >
> > > john

Re: D7-ReStore-ODBC-SQlite

<c03a8d11-a50c-47e2-bcbd-c8cb3526922dn@googlegroups.com>

 copy mid

https://www.novabbs.com/devel/article-flat.php?id=9956&group=comp.lang.smalltalk.dolphin#9956

 copy link   Newsgroups: comp.lang.smalltalk.dolphin
X-Received: by 2002:a37:e315:: with SMTP id y21mr2669247qki.418.1618482622726;
Thu, 15 Apr 2021 03:30:22 -0700 (PDT)
X-Received: by 2002:aca:a990:: with SMTP id s138mr2163492oie.80.1618482622278;
Thu, 15 Apr 2021 03:30:22 -0700 (PDT)
Path: i2pn2.org!i2pn.org!weretis.net!feeder8.news.weretis.net!proxad.net!feeder1-2.proxad.net!209.85.160.216.MISMATCH!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: comp.lang.smalltalk.dolphin
Date: Thu, 15 Apr 2021 03:30:22 -0700 (PDT)
In-Reply-To: <f56290c9-66fd-4130-8422-b8da42bf5bc8n@googlegroups.com>
Injection-Info: google-groups.googlegroups.com; posting-host=106.51.80.86; posting-account=wc7UngoAAABlNyOTTL0vlOzP96a0IeHs
NNTP-Posting-Host: 106.51.80.86
References: <b015aeae-6ee5-492b-963e-fa110901ade2@googlegroups.com>
<176488d8-7d0e-47f7-95c8-b0fa4a2b9c7e@googlegroups.com> <3568c334-522e-49f3-b102-2d1293859ef0@googlegroups.com>
<215be7ce-0759-4fd2-8cd4-9cc06484f302@googlegroups.com> <35fd1a79-ba51-488f-ab46-fce717157f87n@googlegroups.com>
<f56290c9-66fd-4130-8422-b8da42bf5bc8n@googlegroups.com>
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <c03a8d11-a50c-47e2-bcbd-c8cb3526922dn@googlegroups.com>
Subject: Re: D7-ReStore-ODBC-SQlite
From: sanjay.m...@gmail.com (Sanjay Minni)
Injection-Date: Thu, 15 Apr 2021 10:30:22 +0000
Content-Type: text/plain; charset="UTF-8"
 by: Sanjay Minni - Thu, 15 Apr 2021 10:30 UTC

Thanks John,
will move on this
but a native client for Dolphin-SQLite would be great as it can mean a hasslefree install lean app file for windows which otherwise Dolphin is really perfect for

Sanjay

On Thursday, 15 April, 2021 at 1:59:08 pm UTC+5:30, john.a...@gmail.com wrote:
> Hi Sanjay,
>
> ReStore for Dolphin currently only supports database connections via ODBC so you'd need to ensure the SQLite ODBC driver is installed on a target machine.
>
> You can avoid the need to set up an ODBC datasource by specifying a connectString rather than a dsn, for example:
>
> aReStore connectString: 'DRIVER=SQLite3 ODBC Driver;Database=c:\mydb.db'
>
> Porting the SQLite native client from Pharo is on my to-do list so will hopefully happen at some point.
>
> Hope this helps,
>
> John
> On Thursday, April 15, 2021 at 5:48:07 AM UTC+1, Sanjay Minni wrote:
> > (Subject Changed)
> >
> > Hi John (Aspinall),
> >
> > is it required for D7-ReStore-SQLite to go thru ODBC.
> >
> > I was looking to reduce any dependency on the local Windows user installation.
> >
> > Is there a possibility of a single 32 bit package incl SQLite DLL and all drivers without having to depend on any pre-existing files / support from Windows or making any entry in the registry.
> >
> > (I am using http://www.ch-werner.de/sqliteodbc/)
> >
> > regards
> > Sanjay
> > On Monday, 3 June, 2019 at 1:28:29 pm UTC+5:30, john.a...@gmail.com wrote:
> > > Hi John - ReStore, my object-relational interface for Dolphin, provides transparent persistency to a relational database and is actively maintained:
> > >
> > > https://github.com/rko281/ReStore
> > >
> > > Persistency is entirely through normal Smalltalk methods; ReStore takes care of creating and maintaining the database structure so no relational knowledge is needed. Used with SQLite it can provide fast, file-based persistency similar to Omnibase.
> > >
> > > Feel free to message me if you'd like more details.
> > >
> > > Cheers.
> > >
> > > John
> > > On Monday, June 3, 2019 at 1:05:23 AM UTC+1, john c wrote:
> > > > On Sunday, June 2, 2019 at 6:58:18 PM UTC-4, Richard Ronteltap wrote:
> > > > > I think it's removed because of lack of UTF8 support.
> > > > > https://github.com/dolphinsmalltalk/Dolphin/issues/580
> > > >
> > > > thanks.
> > > >
> > > > does anyone have a functional equivalent to omnibase?
> > > >
> > > > john

Re: D7-ReStore-ODBC-SQlite

<3094da9d-082a-457c-88b4-a04f3ce0b0d5n@googlegroups.com>

 copy mid

https://www.novabbs.com/devel/article-flat.php?id=9957&group=comp.lang.smalltalk.dolphin#9957

 copy link   Newsgroups: comp.lang.smalltalk.dolphin
X-Received: by 2002:a05:620a:1592:: with SMTP id d18mr4961710qkk.329.1618513441065;
Thu, 15 Apr 2021 12:04:01 -0700 (PDT)
X-Received: by 2002:aca:f245:: with SMTP id q66mr3679183oih.179.1618513440676;
Thu, 15 Apr 2021 12:04:00 -0700 (PDT)
Path: i2pn2.org!i2pn.org!news.swapon.de!news.uzoreto.com!news.muarf.org!nntpfeed.proxad.net!proxad.net!feeder1-2.proxad.net!209.85.160.216.MISMATCH!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: comp.lang.smalltalk.dolphin
Date: Thu, 15 Apr 2021 12:04:00 -0700 (PDT)
In-Reply-To: <c03a8d11-a50c-47e2-bcbd-c8cb3526922dn@googlegroups.com>
Injection-Info: google-groups.googlegroups.com; posting-host=192.155.0.198; posting-account=QrQDZgoAAAA8V2PxgZzRUNPWEZF7Lfj9
NNTP-Posting-Host: 192.155.0.198
References: <b015aeae-6ee5-492b-963e-fa110901ade2@googlegroups.com>
<176488d8-7d0e-47f7-95c8-b0fa4a2b9c7e@googlegroups.com> <3568c334-522e-49f3-b102-2d1293859ef0@googlegroups.com>
<215be7ce-0759-4fd2-8cd4-9cc06484f302@googlegroups.com> <35fd1a79-ba51-488f-ab46-fce717157f87n@googlegroups.com>
<f56290c9-66fd-4130-8422-b8da42bf5bc8n@googlegroups.com> <c03a8d11-a50c-47e2-bcbd-c8cb3526922dn@googlegroups.com>
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <3094da9d-082a-457c-88b4-a04f3ce0b0d5n@googlegroups.com>
Subject: Re: D7-ReStore-ODBC-SQlite
From: glennswa...@gmail.com (Glenn Swanlund)
Injection-Date: Thu, 15 Apr 2021 19:04:01 +0000
Content-Type: text/plain; charset="UTF-8"
 by: Glenn Swanlund - Thu, 15 Apr 2021 19:04 UTC

On Thursday, 15 April 2021 at 03:30:24 UTC-7, Sanjay Minni wrote:
> Thanks John,
> will move on this
> but a native client for Dolphin-SQLite would be great as it can mean a hasslefree install lean app file for windows which otherwise Dolphin is really perfect for
>
> Sanjay
> On Thursday, 15 April, 2021 at 1:59:08 pm UTC+5:30, john.a...@gmail.com wrote:
> > Hi Sanjay,
> >
> > ReStore for Dolphin currently only supports database connections via ODBC so you'd need to ensure the SQLite ODBC driver is installed on a target machine.
> >
> > You can avoid the need to set up an ODBC datasource by specifying a connectString rather than a dsn, for example:
> >
> > aReStore connectString: 'DRIVER=SQLite3 ODBC Driver;Database=c:\mydb.db'
> >
> > Porting the SQLite native client from Pharo is on my to-do list so will hopefully happen at some point.
> >
> > Hope this helps,
> >
> > John
> > On Thursday, April 15, 2021 at 5:48:07 AM UTC+1, Sanjay Minni wrote:
> > > (Subject Changed)
> > >
> > > Hi John (Aspinall),
> > >
> > > is it required for D7-ReStore-SQLite to go thru ODBC.
> > >
> > > I was looking to reduce any dependency on the local Windows user installation.
> > >
> > > Is there a possibility of a single 32 bit package incl SQLite DLL and all drivers without having to depend on any pre-existing files / support from Windows or making any entry in the registry.
> > >
> > > (I am using http://www.ch-werner.de/sqliteodbc/)
> > >
> > > regards
> > > Sanjay
> > > On Monday, 3 June, 2019 at 1:28:29 pm UTC+5:30, john.a...@gmail.com wrote:
> > > > Hi John - ReStore, my object-relational interface for Dolphin, provides transparent persistency to a relational database and is actively maintained:
> > > >
> > > > https://github.com/rko281/ReStore
> > > >
> > > > Persistency is entirely through normal Smalltalk methods; ReStore takes care of creating and maintaining the database structure so no relational knowledge is needed. Used with SQLite it can provide fast, file-based persistency similar to Omnibase.
> > > >
> > > > Feel free to message me if you'd like more details.
> > > >
> > > > Cheers.
> > > >
> > > > John
> > > > On Monday, June 3, 2019 at 1:05:23 AM UTC+1, john c wrote:
> > > > > On Sunday, June 2, 2019 at 6:58:18 PM UTC-4, Richard Ronteltap wrote:
> > > > > > I think it's removed because of lack of UTF8 support.
> > > > > > https://github.com/dolphinsmalltalk/Dolphin/issues/580
> > > > >
> > > > > thanks.
> > > > >
> > > > > does anyone have a functional equivalent to omnibase?
> > > > >
> > > > > john
Martin Rubi had a native Dolphin package for SQLite. Not sure how to contact him.

1
server_pubkey.txt

rocksolid light 0.9.7
clearnet tor