[Gambas-user] SQLite - in memory DB

[zainudin ahmad]

I can't use it too (attach pic), it's bug ? (attach project)

On Sun, Jun 19, 2016 at 5:57 PM, Vinode Singh Ujlain <ujlain at ...626...>
wrote:

> Public conH As New Connection
> conH.Type = "sqlite3"
> conH.name = ":memory:"
>   Try conH.Open()
>    If Error Then
>      Print "Unable to open database \n Error :"; Error.Text
> ....
> ....
>
> Error I am getting is :-
> /Unable to open database //
> //Error : Unable to locate database `:memory:` in ``/
>
> conH.name = Null /'does work but that is creating a temp database in
> /tmp folder and marginally slower/
>
> I request opinion on following :-
> (a) How to create "in memory" Sqlite DB so that the operations can be
> done expeditiously.
> (b) Further how to attach using GAMBAS an existing file based Sqlite and
> how to shift one table from this to in-memory DB ?
>
> regards
> Vinode Singh
>
> ------------------------------------------------------------------------------
> What NetFlow Analyzer can do for you? Monitors network bandwidth and
> traffic
> patterns at an interface-level. Reveals which users, apps, and protocols
> are
> consuming the most bandwidth. Provides multi-vendor support for NetFlow,
> J-Flow, sFlow and other flows. Make informed decisions using capacity
> planning
> reports. http://sdm.link/zohomanageengine
> _______________________________________________
> Gambas-user mailing list
> Gambas-user at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/gambas-user
>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: pic-1.png
Type: image/png
Size: 17993 bytes
Desc: not available
URL: <http://lists.gambas-basic.org/pipermail/user/attachments/20160620/ff2c2ea5/attachment.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: test-db-sqlite-memory-0.0.1.tar.gz
Type: application/x-gzip
Size: 11435 bytes
Desc: not available
URL: <http://lists.gambas-basic.org/pipermail/user/attachments/20160620/ff2c2ea5/attachment.bin>