>sqlfile_demo <- getSQLiteFile(destdir = "~/bin/Rpack", destfile = "GEOmetadb.sqlite_demo.gz",type="demo")
>con <- dbConnect(SQLite(),sqlfile_demo)
>getBiocPlatformMap(con)[1:5,]

output:
title      gpl                 bioc_package         manufacturer
1                                      [Maize] Affymetrix Maize Genome Array  GPL4032                                        Affymetrix
2 Agilent-026652 Whole Human Genome Microarray 4x44K v2 (Probe Name version) GPL13497        HsAgilentDesign026652 Agilent Technologies
3     Illumina HumanMethylation27 BeadChip (HumanMethylation27_270596_v.1.2)  GPL8490  IlluminaHumanMethylation27k       Illumina, Inc.
4       Illumina HumanMethylation450 BeadChip (HumanMethylation450_15017482) GPL13534 IlluminaHumanMethylation450k       Illumina, Inc.
5                                   [AG] Affymetrix Arabidopsis Genome Array    GPL71                           ag           Affymetrix
              organism data_row_count
1             Zea mays          17734
2         Homo sapiens          34184
3         Homo sapiens          27578
4         Homo sapiens         485577
5 Arabidopsis thaliana           8297

>object.size(con)

output
2112 bytes

>sqlfile <- getSQLiteFile(destdir = "~/bin/Rpack", destfile = "GEOmetadb.sqlite.gz",type="normal")
>con<-dbConnect(SQLite(),sqlfile)
>getBiocPlatformMap(con)[1:5,]

output
title  gpl bioc_package manufacturer organism data_row_count
NA    <NA> <NA>         <NA>         <NA>     <NA>             NA
NA.1  <NA> <NA>         <NA>         <NA>     <NA>             NA
NA.2  <NA> <NA>         <NA>         <NA>     <NA>             NA
NA.3  <NA> <NA>         <NA>         <NA>     <NA>             NA
NA.4  <NA> <NA>         <NA>         <NA>     <NA>             NA


>object.size(con)

output
2096 bytes