(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

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

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

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

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

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

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.

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