Embed SQLite Database

While uploading bulk data from datatabe to the database using the insert datatable activity it is taking too much time , but when i do the same thing with one insert command which holds the entier data its just millisecond 

can you tell me what could be done to improve the insert part for the datatable ?

Hi Thiago,

About the version mismatch:

Thank you for you quick responce. Have you come to any conclusion?

Thanks!

Jesper

----------------------------------------------------------------------------

There seems to be a mismatch in the System.Data.SQLite.dll dependancy reference. v. 109 is bundeled but 110 is referenced.

When publishing a library using Embed SQLite Database UiPath can not compile.

Hi Thiago,

Great project - Thanks!

Are you still maintaining this? There seems to be a mismatch in the System.Data.SQLite.dll dependancy reference. v. 109 is bundeled but 110 is referenced.

When publishing a library using Embed SQLite Database UiPath can not compile.

Thanks!

Jesper

Hi, i need to insert a dataTable to SQLite but when I use copyToDatatable method it doesn't work. the linq I use ; dt.AsEnumerable.Take(1000).CopyToDataTable   .   anyone has any idea?

Hi, I am new to UiPath, can anyone guide me how to install this package ?

I am using community edition and its not getting connected to Orchestrator ( or not able to login due to proxy issue of this company laptop)

How can I install this downlaoded package manully ?

Thanks in advanace.

Example please

Hello Thiago, 

thank you for the component - great stuff. 

Couple questions: 

1. if I create a SQLite database whatever.db on a shared folder mapped to a network drive it creates the .db file but throws error whether I try connecting the SQLite db through the full path in the form //123.456.78.900/SharedFolder/whatever.db; it does work fine using the local path in the form W:/whatever.db where W: is the windows mapped drive. Is it intended?
2. Is there any concurrent access management in the InsertDatatable activity? Your package would be pure gold when we got multiple robots dealing with the same process, same process reporting or same process output provided that several bots can write to the same SQLite database without messing or interfering each other

thanks again

see you

dario

Hello Thiago,

It is a great component.

Is there any possibility to improve the efficiency for the "Insert" activity?

I found the transacation size is a bit too small. When I was tring to insert 200,000 records with 15 columns , it took a long time.

Hello Thiago,

Thanks for the component. Is there a way to create the SQLite Database with authentication. This is a security audit requirement.

Thanks,

Nithin