Android Tutorial ✅ [B4X] [XUI] [B4XPages] B4A PreoptimizedCLV lazy loading from SQLite and CSV - Newer developers

Hello to you all,
Welcome to Sheldon Coopers and Amy Farrah Fowlers fun with flags

Here is a simple example on using B4XPages with both an SQLite database and also a CSV file with multiple PreoptimizedCLV to retrieve country population data and flag images. Using a PreoptimizedCLV to display rows of data, card, images etc is extremely efficient and fast, even on older or slower devices.

When it comes to the CSV file, yes I could have imported the file list of ISO 3166 country codes and names into the SQLite database into a new table, but this post is about showing new to B4X developers how to manipulate files and insert the data into multiple PreoptimizedCLV. The CSV file has 249 rows (2 columns) and the SQLite database table has 280,932 rows of data, the population data ranges from 1950 (fact) to 2100 (estimated), there are also 252 flag images. The code in B4XMainPage is relatively simple to follow and works with B4A, B4i and also B4J, I've added comments where feasible to do so.

The population data comes directly from the UN, link below.

Population Division |

www.un.org

>>> CLICK HERE <<< to download the B4XPages source code.

B4i and B4J posts

✅ [B4X] [XUI] [B4XPages] B4i PreoptimizedCLV lazy loading from SQLite and CSV - Newer developers

Hello to you all, Welcome to Sheldon Coopers and Amy Farrah Fowlers fun with flags ;) Here is a simple example on using B4XPages with both an SQLite database and also a CSV file with multiple PreoptimizedCLV to retrieve country population data and flag images. Using a PreoptimizedCLV to display...

www.b4x.com

✅ [B4X] [XUI] [B4XPages] B4J PreoptimizedCLV lazy loading from SQLite and CSV - Newer developers

Hello to you all, Welcome to Sheldon Coopers and Amy Farrah Fowlers fun with flags ;) Here is a simple example on using B4XPages with both an SQLite database and also a CSV file with multiple PreoptimizedCLV to retrieve country population data and flag images. Using a PreoptimizedCLV to display...

www.b4x.com

Libraries needed:

Android screenshots below:

Main screen

Combobox country list

Filtered searches use a PreoptimizedCLV

Flags are displayed in a PreoptimizedCLV

Enjoy...

 

[Erel]

Great work Peter!

 

[Peter Simpson]

Great work Peter!

Thank you...

 

[AnandGupta]

@Peter Simpson , your contributions for benefit of B4X members, are priceless ?

Regards,

Anand

 

[invocker]

link not work https://www.dropbox.com/s/miy8lu2jtd20zce/WorldPopultion1.zip?dl=0

 

[LucaMs]

Welcome to Sheldon Coopers and Amy Farrah Fowlers fun with flags

? ? ?