Uipath Marketplace

サインイン

はじめてのオートメーションをわずか数分で作成できます。Studio Web を試す

Embed SQLite Database

Embed SQLite Database

作成者: Thiago Minhaqui Oechsler

5

アクティビティ

ダウンロード数

26.8k

Sagar Raval
3 years 前に投稿

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 ?

Jesper Rasmussen
3 years 前に投稿

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.

Jesper Rasmussen
3 years 前に投稿

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

Thiago Minhaqui Oechsler
3 years ago 前に投稿

Hey Jesper, thanks for the feedback. I was not aware of this issue. I will investigate.

Thiago Minhaqui Oechsler
3 years ago 前に投稿

Hey Jesper, thanks for the feedback. I was not aware of this issue. I will investigate.

Arif Kılıç
4 years 前に投稿

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.

Thiago Minhaqui Oechsler
4 years ago 前に投稿

Hi Chandrakant, please refer to the Uipath Documentation on how to install packages.

https://docs.uipath.com/orchestrator/docs/managing-packages

Connection to Orchestrator is another issue altogether which I also recommend you to look for Documentation.

https://docs.uipath.com/orchestrator/docs/connecting-robots-to-orchestrator

Thanks!

esteffany gutierrez
4 years 前に投稿

Example please

Thiago Minhaqui Oechsler
4 years ago 前に投稿

Hi Esteffany

Please look into the example available at this GitHub repo:

https://github.com/ThiagoOechsler/SQLiteUiPathActivities/raw/master/SQLite%20Example%20-%20UiPath%20Studio%202021.4.4.zip

Dario Casubolo
4 years 前に投稿

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

Thiago Minhaqui Oechsler
4 years ago 前に投稿

Hello Dario,

Will need more details about the error/exception to investigate.

Can you shoot me a private message on UiPath forum with the error message?

Thanks!

Yi Li
5 years 前に投稿

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.

Thiago Minhaqui Oechsler
4 years ago 前に投稿

Hello Yi Li,

The component uses a single instruction from SQL library to insert/update data. The performance you are getting is coming from it, not related to the UiPath component wrapper.

However, in my opinion, if you are using SQLite to load/update this amount of rows frequently, the SQLite database is not your recommended persistence point. You should look for a more robust DBMS in this case.  

In the other hand, if you are doing a one time load of 200k rows, then I think you let your stakeholders know this could take a while on the first time. :)

Thanks!

Nithin Prabhu
5 years 前に投稿

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

Thiago Minhaqui Oechsler
5 years ago 前に投稿

Hi Nithin,

SQLite3 DB allows to protect the database with a password. This is a cool addition to the package and I will definetly evaluate to add this to the activities.

However, after adding a password, the entire datafile is encrypted and it will limit the tools you can use to "manage" the database file.

Thanks!

公開者

Thiago Minhaqui Oechsler

公開者ページを表示

ライセンス契約とプライバシー条項

MIT

プライバシー条項

技術情報

バージョン

1.0.17

更新日

2020年2月18日

対応製品

Studio: 21.10 - 22.10

認定

シルバー 認定済み

サポート

UiPath コミュニティ サポート

リソース