Database & Integration

G-SDK Introduction
G-SDK Introduction In addition to the integration method using BioStar2 SW API or BioStar2 Device SDK, G-SDK is recently released as a new integration opti...
Thu, Apr 23, 2020 at 4:04 PM
[BioStar 1] Device Disconnection When Event Log Table Has More Than 10 Million Logs
Once more than 10 million logs are gathered, devices may start to have connectivity issues because the BioStar database has too many logs. In this case you ...
Thu, Mar 5, 2020 at 10:45 AM
[BioStar 1] How to check the size of LDF file and reduce the size of the file (MSSQL)
MS SQL database includes MDF file and LDF file.  MDF is actual data of an application and LDF file is a transaction log file which records the q...
Wed, Mar 4, 2020 at 9:15 AM
[BioStar 2] Device time format in the DB t_lgyyyymm
In the DB table t_lgyyyymm, you will see SRVDT but SRVDT is not event happened time. It is only the time the DB is synchronized to the server. Thus, you nee...
Wed, Feb 19, 2020 at 3:55 PM
[BioStar 2] How To Check Your Maria DB Version
The progress of BioStar2 Express Installation installs Maria DB 10.1.10, therefore BioStar2 SW is compatible with the version 10.1.10 of Maria DB. If yo...
Tue, Oct 1, 2019 at 1:23 PM
[BioStar 2] Where face template is stored in BioStar 2 database?
The user ID in BioStar 2 is USRID. Check the USRUID of the user in t_usr.  BioStar 2 User ID = USRID = 1 USRUID = 1001 [t_usr] Check CRDTUID ...
Thu, May 9, 2019 at 11:13 AM
[BioStar 2] Uploading Users from Device to Server (Fresh Install of BioStar 2 with Users in Device)
Warning: BioStar 2.5's automatic user synchronization feature will automatically synchronize the device with the server even before you click 'syn...
Wed, Apr 18, 2018 at 2:28 PM
[BioStar 2] Checking T&A Logs in the T&A Database
If you are considering to create a database link program with BioStar database with your third party software, please do not take logs from the T&A data...
Mon, Oct 8, 2018 at 2:59 PM
[General] How to Export Database Table into an Excel File (BioStar 1 MSSQL Database Example)
This material will introduce you on exporting table contents into an excel file. *Before this event, you must be able to connect to your database on SQL...
Wed, Sep 19, 2018 at 3:24 PM
[BioStar 1] Viewing user information from the database (Database Example)
*This is for any users who are confused on how to view user information correctly on a database using SQL Server Management Studio - for database backup an...
Tue, Sep 18, 2018 at 2:32 PM