SQLite

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

SQLite

Joe Daugherty

I was trying to inspect the records in the data base.

SQLite3_analyzer can see the various tables

REFERENCE......................................... 45          28.8%

PERSON............................................ 23          14.7%

EVENT............................................. 22          14.1%

PLACE............................................. 19          12.2%

FAMILY............................................ 9            5.8%

MEDIA............................................. 8            5.1%

CITATION.......................................... 6            3.8%

NOTE.............................................. 6            3.8%

SOURCE............................................ 4            2.6%

REPOSITORY........................................ 3            1.9%

SQLITE_MASTER..................................... 3            1.9%

TAG............................................... 3            1.9%

METADATA.......................................... 2            1.3%

NAME_GROUP........................................ 2            1.3%

GENDER_STATS...................................... 1            0.64%

 

I can start SQL on the database

But I cannot see the list of tables nor can I select the values from any of the tables;

 

Any thoughts why the data is hiding from me

 

Joe Daugherty

 

New to gramps

Familiar with oracle, Informix, and unify SQL

30 years in genealogy

 



--
Gramps-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/gramps-users
https://gramps-project.org
Reply | Threaded
Open this post in threaded view
|

Re: SQLite

Ron Johnson
On 12/1/19 7:18 PM, Joe Daugherty wrote:

I was trying to inspect the records in the data base.

SQLite3_analyzer can see the various tables

REFERENCE......................................... 45          28.8%

PERSON............................................ 23          14.7%

EVENT............................................. 22          14.1%

PLACE............................................. 19          12.2%

FAMILY............................................ 9            5.8%

MEDIA............................................. 8            5.1%

CITATION.......................................... 6            3.8%

NOTE.............................................. 6            3.8%

SOURCE............................................ 4            2.6%

REPOSITORY........................................ 3            1.9%

SQLITE_MASTER..................................... 3            1.9%

TAG............................................... 3            1.9%

METADATA.......................................... 2            1.3%

NAME_GROUP........................................ 2            1.3%

GENDER_STATS...................................... 1            0.64%

 

I can start SQL on the database

But I cannot see the list of tables nor can I select the values from any of the tables;

 

Any thoughts why the data is hiding from me


What do you mean?

ron@haggis:~$ sqlite3 /home/ron/.gramps/grampsdb/5c1d6859/sqlite.db
SQLite version 3.22.0 2018-01-22 18:45:57
Enter ".help" for usage hints.
sqlite> .tables
citation      gender_stats  name_group    place         source     
event         media         note          reference     tag        
family        metadata      person        repository 


--
Angular momentum makes the world go 'round.


--
Gramps-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/gramps-users
https://gramps-project.org