Git Product home page Git Product logo

Comments (5)

jimmyH avatar jimmyH commented on August 11, 2024

I have not seen any documentation on how VW uses the database(s). Both MIB2HIGH and MIB2TSD use sqlite3 databases which you can read about at https://www.sqlite.org

MIB2HIGH uses virtual tables to speed up searching. The poicoord_* and poiname_* tables are used internal to sqlite to handle these virtual tables. We can only use the poidata and poicoord tables.

from mypois.

1e1 avatar 1e1 commented on August 11, 2024

Ok, it's very light :/

pPoiSystemTable.personalComment is used for each category, not for each POI.

But pPoiId is the primary key and catId is a foreign key.

I dumped the database:

sqlite3 ./SD_CARD/PersonalPOI/MIB2TSD/personalpoi/ppoidb/1/default/poidata.db3 .dump > dump.sql
grep -n pPoiSystemTable ./dump.sql | head -10
58151:CREATE TABLE pPoiSystemTable( pPoiId INTEGER UNIQUE PRIMARY KEY,catId INTEGER NOT NULL,priority INTEGER,sortIndex INTEGER ,personalComment TEXT ,str1 TEXT ,str2 TEXT ,int1 INTEGER ,int2 INTEGER ,version TEXT,isDirty INTEGER , FOREIGN KEY(catId) REFERENCES pPoiCategoryTable(catId) ON UPDATE CASCADE);
58152:INSERT INTO pPoiSystemTable VALUES(1,2001,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
58153:INSERT INTO pPoiSystemTable VALUES(2,2001,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
58154:INSERT INTO pPoiSystemTable VALUES(3,2001,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
58155:INSERT INTO pPoiSystemTable VALUES(4,2001,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
58156:INSERT INTO pPoiSystemTable VALUES(5,2001,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
58157:INSERT INTO pPoiSystemTable VALUES(6,2001,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
58158:INSERT INTO pPoiSystemTable VALUES(7,2001,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
58159:INSERT INTO pPoiSystemTable VALUES(8,2001,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
58160:INSERT INTO pPoiSystemTable VALUES(9,2001,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);

I think we can add a personalComment :)

from mypois.

jimmyH avatar jimmyH commented on August 11, 2024

You are right, I was just getting confused :)

The only question is whether the MIB2TSD displays the personalComment...

from mypois.

1e1 avatar 1e1 commented on August 11, 2024

I tested on VW Sharan (revision 2015), I don't know if i'm using MIB2TSD or MIB2HIGH.
I stuff personalComment on MIB2TSD but I cann't see its content on my GPS.

from mypois.

1e1 avatar 1e1 commented on August 11, 2024

I can confirm my Sharan (revision 2015) is using MIB2TSD(not MIB2HIGH).
Values in personalComment are not displayed on my screen.

from mypois.

Related Issues (7)

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.