Forum ‹ BigDB ‹ Pre populating tables

[capitaljmedia]

Hi,

Is there a way from the admin dashboard on the site to pre-populate the tables in my DB? Like in MYSQL you can just edit the database and set it up before you start to access it from your code.

The whole setup of the BigDB seems like it could use some more instructions, it's not clear what is the value to the right of the property name... the default value?

[NPSF3000]

You can simply type it out in the control panel.

Or, if you need to push more data, write a client application to populate the table.

"it's not clear what is the value to the right of the property name... the default value?"

Nope - the value of the property for the database object you have just created.

[capitaljmedia]

Hmm, now I think I'm more confused.

So, is each database object like a separate row in the table? I thought it was just the fields/columns of the table.

[NPSF3000]

Table has DBO's.
DBO's have properties.
Tables can have indexs based on DBO properties.

AFAIK that's it.

[Henrik]

Hmm, now I think I'm more confused.

So, is each database object like a separate row in the table? I thought it was just the fields/columns of the table.

BigDB is a NoSQL document database. Each DatabaseObject in a table has a unique key, and that's it as far as requirements go. On each object you can then put properties, each property has a name, a type, and a value. There are no default values, and no constraints on properties. You can read more here:

http://playerio.com/documentation/bigdb/objects

[capitaljmedia]

So each database object can be unique?

Is there a quick way to add several objects of the exact same type but with different values. I'm sure you can do this in code, but I would like to first pre-populate the table without having to create the properties for each object with every entry.

[Henrik]

Sorry, no, we do not provide any other interface than the current BigDB admin interface.