Re: Viable lightweight Smalltalk based DB copasetic with 9.3

Charles,

I already answered along these lines - unfortunately hitting the wrong 
answer button (DM instead of mailing list).

As an extra explanation, in case you didn't know: SQLite is different 
than other DBMS. It is just a DLL (or equivalent on other platforms). No 
installation package, no "server", no hassle. You simply ship the DLL 
with your product. The DB is just a simple file that can be copied, 
backed-up etc., just like any other file. So you can even ship some 
"initial DB" witht your product if you wish. SQLite is so lightweight 
that it is used on smartphones and IoT devices. So I think it absolutely 
is worth a look. Add to that that there are lots of external (gui and 
command line) tools that you can use to query the database.

I think I am not the only one wondering what your reason for "no rdbms" 
might be. All other alternatives are rather "exotic" as compared to 
SQLite. In the end, you can even go so far as to switch to a "big DB" 
without code changes, should there ever be a need.

BTW: I just released two small articles of a planned mini-series for 
SQLIte with Glorp and VAST platform - it should not be too far off for 
VW. Maybe you want to take a look:

joachimtuchel.wordpress.com

Getting Started with SQLite, Glorp and VAST Platform – Pt. 1 <#>

VAST Platform ships with Support for SQLite, a very lightweight and easy 
to use SQL database. One very nice feature of it is that you can run it 
as a mere in-memory database. From time to time I fi…

🔗 
https://urldefense.com/v3/__https://joachimtuchel.wordpress.com/2023/10/11/getting-started-with-sqlite-glorp-and-vast-platform-pt-1/__;!!DZ3fjg!71_9zRWlLrYjn84Aa0VNO0ZtED9Q3zFp7GlrWZhh5c3UqdyDtN71dXVYqBqsAyITIz5MmjA3gpk3I_rF9meRWNFZd_nUDf4$  
<https://urldefense.com/v3/__https://joachimtuchel.wordpress.com/2023/10/11/getting-started-with-sqlite-glorp-and-vast-platform-pt-1/__;!!DZ3fjg!71_9zRWlLrYjn84Aa0VNO0ZtED9Q3zFp7GlrWZhh5c3UqdyDtN71dXVYqBqsAyITIz5MmjA3gpk3I_rF9meRWNFZd_nUDf4$ > 


What's interesting is that the whole setup is a lot easier than I 
thought, so, tbh, I don't really know what else to write in the next 
part ;-)



Joachim


Am 18.10.23 um 14:49 schrieb Thomas Sattler:
> SQLite definitely works with the latest versions of VW.  Charles' 
> requirements implied that he does not want relational, but if he would 
> relax that particular point, SQLite would fit all the others perfectly.
>
>
>
> On Tue, Oct 17, 2023 at 4:27 PM Cesar Rabak <[email protected]> wrote:
>
>     Your description seems to /almost/ fit with Embarcadero's
>     Interbase, however, I'm not sure if there's still a parcel for
>     binding this DB in recent versions of VW.
>
>     HTH
>
>     On Tue, Oct 17, 2023 at 2:10 PM Charles Monteiro
>     <[email protected]> wrote:
>
>         lightweight, something that you would ship with your product ,
>         preferably that could run on Windows, Mac , Linux, not an
>         RDMS, something that would not require the user to do any
>         specific installation of the DB or have to do any maintenance
>         of the DB. Effectively embedded but something that had some
>         nice semantics i.e. not BOSS, does not have to be multi user ,
>         it could just be persisted in a file or set of local files ,
>         but not something that you would load entirely into memory,
>         ideally something that would persist Smalltalk objects , to my
>         recollection that's exactly what Omnibase did, although I
>         actually think it was multi-user but it didn't have to be used
>         as such
>
>         thanks
>
>         On Mon, Oct 16, 2023 at 4:07 AM Nowak, Helge
>         <[email protected]> wrote:
>
>             What are your requirements with regards to the DB?
>
>             What exactly do you mean by “lightweight?
>
>             Cheers
>
>             Helge
>
>             *Helge Nowak
>             *Cincom Smalltalk Technical Account Manager**
>
>             https://urldefense.com/v3/__http://internal.cincom.com/signature/logo.png__;!!DZ3fjg!71_9zRWlLrYjn84Aa0VNO0ZtED9Q3zFp7GlrWZhh5c3UqdyDtN71dXVYqBqsAyITIz5MmjA3gpk3I_rF9meRWNFZHmHvmRE$ 
>             <https://urldefense.com/v3/__http://www.cincomsmalltalk.com/__;!!DZ3fjg!-7205CmUvWfPYsOOHVTStGywoNAlt6fmAy0cYKiPItnX79T512kmIvRT3cG8qjlLNEdXPsgLVqqtUp_ar61svLNa4CETppCqlw$>
>             Cincom Systems GmbH & Co. oHG
>             Humboldtstraße 3
>             60318 Frankfurt am Main
>             GERMANY
>
>             	
>
>             office
>             mobile
>
>             website
>             email
>
>             	
>
>             +49 89 89 66 44 94
>             +49 172 74 00 402
>
>             https://urldefense.com/v3/__https://www.cincomsmalltalk.com__;!!DZ3fjg!71_9zRWlLrYjn84Aa0VNO0ZtED9Q3zFp7GlrWZhh5c3UqdyDtN71dXVYqBqsAyITIz5MmjA3gpk3I_rF9meRWNFZye4M0Rc$ 
>             <https://urldefense.com/v3/__https://www.cincomsmalltalk.com__;!!DZ3fjg!-7205CmUvWfPYsOOHVTStGywoNAlt6fmAy0cYKiPItnX79T512kmIvRT3cG8qjlLNEdXPsgLVqqtUp_ar61svLNa4CEgWlZFcg$>
>             [email protected]
>
>             /A standpoint is an intellectual horizon of radius zero.
>             -- Albert Einstein
>
>             /
>
>             Geschäftsführer/Managing Directors: Thomas M. Nies, Donald
>             E. Vick
>             oHG mit Sitz/based in Frankfurt am Main (Amtsgericht
>             Frankfurt am Main HRA 50297)
>             Pers. haftender Gesellschafter/Partner liable to unlimited
>             extent:
>             Cincom Systems Verwaltungsgesellschaft mbH (Amtsgericht
>             Königstein/Ts. HRB 5069)
>
>             --- CONFIDENTIALITY STATEMENT ---
>
>             This e-mail transmission contains information that is
>             intended to be privileged and confidential. It is intended
>             only for the addressee named above. If you receive this
>             e-mail in error, please do not read, copy or disseminate
>             it in any manner. If you are not the intended recipient,
>             any disclosure, copying, distribution or use of the
>             contents of this information is prohibited, please reply
>             to the message immediately by informing the sender that
>             the message was misdirected. After replying, please erase
>             it from your computer system. Your assistance in
>             correcting this error is appreciated.
>
>             *Von:* [email protected]
>             <[email protected]> *Im Auftrag von
>             *Charles Monteiro
>             *Gesendet:* Freitag, 13. Oktober 2023 20:27
>             *An:* [email protected]
>             *Betreff:* [vwnc] Viable lightweight Smalltalk based DB
>             copasetic with 9.3
>
>             CAUTION:This email originated from outside of Cincom's
>             email system. Do not click links or open attachments
>             unless you recognize the sender and know the content is
>             safe. Thanks - If in doubt, contact the Helpdesk at
>             [email protected] or your local IT personnel.
>
>             So no "have you tried BOSS" pls :)
>
>             I recall OmniBase for example but not sure if that's
>             currently the best thing going or if it breaks in 9.3 . I
>             don't want to use Mongo for this particular project and
>             thus the request.
>
>             thanks
>
>             -- 
>
>             Charles A. Monteiro
>             https://urldefense.com/v3/__http://www.monteirosfusion.com__;!!DZ3fjg!71_9zRWlLrYjn84Aa0VNO0ZtED9Q3zFp7GlrWZhh5c3UqdyDtN71dXVYqBqsAyITIz5MmjA3gpk3I_rF9meRWNFZ0SV3m6U$ 
>             <https://urldefense.com/v3/__http:/www.monteirosfusion.com__;!!DZ3fjg!-4zpmIWDamgI79l-b6T01y9neYi4WqrhXo_qLRTdxT6INPZ9vSgq_SGc0ZokGExVQj3A51sXOqhadXVtgTsnS4jHKHvKHEy5sA$>
>             sent from the road
>
>
>
>         -- 
>         Charles A. Monteiro
>         https://urldefense.com/v3/__http://www.monteirosfusion.com__;!!DZ3fjg!71_9zRWlLrYjn84Aa0VNO0ZtED9Q3zFp7GlrWZhh5c3UqdyDtN71dXVYqBqsAyITIz5MmjA3gpk3I_rF9meRWNFZ0SV3m6U$ 
>         <https://urldefense.com/v3/__http://www.monteirosfusion.com__;!!DZ3fjg!-7205CmUvWfPYsOOHVTStGywoNAlt6fmAy0cYKiPItnX79T512kmIvRT3cG8qjlLNEdXPsgLVqqtUp_ar61svLNa4CF0_YIkkg$>
>         sent from the road
>
-- 

-----------------------------------------------------------------------
Objektfabrik Joachim Tuchelmailto:[email protected]  
Fliederweg 1https://urldefense.com/v3/__http://www.objektfabrik.de__;!!DZ3fjg!71_9zRWlLrYjn84Aa0VNO0ZtED9Q3zFp7GlrWZhh5c3UqdyDtN71dXVYqBqsAyITIz5MmjA3gpk3I_rF9meRWNFZq2mCLMQ$ 
D-71640 Ludwigsburghttp://joachimtuchel.wordpress.com
Telefon: +49 7141 56 10 86 0                    Fax: +49 7141 56 10 86 1