Re: [Pharo-users] Pharo and SQLite

2015-10-18 Thread Hilaire
Le 15/10/2015 20:54, Mariano Martinez Peck a écrit : > SQL queries or even writing mappings via a relational mapper are > always a pain. So, my comment is that if you are willing to NOT have > acid, transactions, and many other of the relational db features, you > can use a simple one-file based ap

Re: [Pharo-users] Pharo and SQLite

2015-10-16 Thread Offray Vladimir Luna Cárdenas
Thanks. Any code review or comments are welcomed. No interface now between fossil and grafoscopio. I just put all my STON files there, but STON + fossil is a combination you could consider also. Cheers, Offray On 15/10/15 23:00, Jimmie Houchin wrote: Okay, I didn't know if you were referring

Re: [Pharo-users] Pharo and SQLite

2015-10-15 Thread Jimmie Houchin
Okay, I didn't know if you were referring to Grafoscopio or not. I did not know it would be using Fossil for storage. I downloaded and will explore next week. Thanks. Jimmie On 10/15/2015 05:37 PM, Offray Vladimir Luna Cárdenas wrote: Hi Jimmie, My idea is to connect Pharo with the externa

Re: [Pharo-users] Pharo and SQLite

2015-10-15 Thread Offray Vladimir Luna Cárdenas
Hi Jimmie, My idea is to connect Pharo with the external world, starting from what I need/know, but also I try to not use every single stuff in other languages. My main criteria for selecting from other ecosystems is simplicity. I want to make Pharo compatible with my own history (which is ki

Re: [Pharo-users] Pharo and SQLite

2015-10-15 Thread Jimmie Houchin
Hello Offray, If we didn't have the big push for GitHub. I would love to see a Fossil source code interface for Pharo. If we had this we could potentially replace SmalltalkHub with something more functional almost instantly. This is a big assumption, but possibly correct. But since it comes wi

Re: [Pharo-users] Pharo and SQLite

2015-10-15 Thread Jimmie Houchin
Thanks for the reply. My idea at the moment to write the application as the user interface to the SQLite database. I do want all of the rdb features. I also explicitly want something that is usable from other languages or environments. I might someday think LuaJIT to be the direction I want to

Re: [Pharo-users] Pharo and SQLite

2015-10-15 Thread Offray Vladimir Luna Cárdenas
Hi Jimmie, Nice to see you exploring bridges between Pharo and the external world (that was my message about how I planned to contribute to pharo) and thanks for the reference about the "Git: just say no" video from Hipp (food for my rants with git possessed friends ;-) ). [1] https://www.yo

Re: [Pharo-users] Pharo and SQLite

2015-10-15 Thread Mariano Martinez Peck
Hi Jimmie, Your approach seems very good from my point of view. As you know, making directly SQL queries or even writing mappings via a relational mapper are always a pain. So, my comment is that if you are willing to NOT have acid, transactions, and many other of the relational db features, you c

Re: [Pharo-users] Pharo and SQLite

2015-10-15 Thread Robert Withers
Thanks to both of you for the links. I appreciate you. Robert On 10/15/2015 02:22 PM, Esteban A. Maringolo wrote: I haven't used SQLite in Pharo, but I used it in Android. It is a pretty complete database solution, self contained in a single file (and a shared library ;-)). I already posted th

Re: [Pharo-users] Pharo and SQLite

2015-10-15 Thread Jimmie Houchin
Thanks for the reply. When I went to answer Robert, I saw that driver. I will definitely give it a try. I don't find the post with those slides. But I have watched the video. It is a good video. Funny! But I did see the one where you posted about advocacy. But this is why I think that SQLit

Re: [Pharo-users] Pharo and SQLite

2015-10-15 Thread Esteban A. Maringolo
Garage's SQLite driver is a clone, albeit outdated, of the NBSQLite3 codebase. So you better stick with NBSQlite3. Esteban A. Maringolo 2015-10-15 15:31 GMT-03:00 Jimmie Houchin : > I would love to have an independent full featured, sold out to SQLite, > adapter for Pharo. However, I have not wr

Re: [Pharo-users] Pharo and SQLite

2015-10-15 Thread Jimmie Houchin
I would love to have an independent full featured, sold out to SQLite, adapter for Pharo. However, I have not written one. The one I have installed but yet to try is the one that is included in Garage. http://smalltalkhub.com/#!/~DBXTalk/Garage But while looking at the link above, I see that

Re: [Pharo-users] Pharo and SQLite

2015-10-15 Thread Esteban A. Maringolo
I haven't used SQLite in Pharo, but I used it in Android. It is a pretty complete database solution, self contained in a single file (and a shared library ;-)). I already posted the slides of the PgCon where Richard Hipp states that SQLite is the replacement of fopen() and not of a whole RDBMS: ht

Re: [Pharo-users] Pharo and SQLite

2015-10-15 Thread Robert Withers
Hi Jimmie, Is this SQlite adaptor you wrote published publicly? I'd definitely like to evaluate this technology for my stack. Thank you, Robet On 10/15/2015 01:58 PM, Jimmie Houchin wrote: Hello, I am working on a project for my wife. I initially thought I would keep all my data inside Phar

[Pharo-users] Pharo and SQLite

2015-10-15 Thread Jimmie Houchin
Hello, I am working on a project for my wife. I initially thought I would keep all my data inside Pharo because it is a simple project and Pharo is great at persistence in the image. But as I pursued the project it felt like I was reinventing the database. So I thought why am I considering w