Has anyone added columns to an RM Table?

#1 · 2025-03-01, 5:23 pm

I'm considering adding a column or 2 to the DnaTable fo my own use.

Looking at the SQLite docs-
https://www.sqlite.org/lang_alterable.html
"After ADD COLUMN has been run on a database, that database will not be readable by SQLite version 3.1.3 (2005-02-20) and earlier."

Does anyone know whether RM uses a more recent version of the SQLite library?

Or have you added a column to a table that went through a schema update?

After consideration, I think that it will be safer to create a new table with my data and join it to the DnaTable.

I have the impression that others have added tables (or just views?) that have gone through schema updates. Correct?

Thanks
Richard Otter

#2 · 2025-03-01, 8:46 pm

Quote from Richard Otter on 2025-03-01, 5:23 pm
Does anyone know whether RM uses a more recent version of the SQLite library?

I don't know. And all SQLite writes into the file header is "SQLite format 3".

Or have you added a column to a table that went through a schema update?

I may have experimented with that a decade or so ago and learned not to!

After consideration, I think that it will be safer to create a new table with my data and join it to the DnaTable.

I agree.

I have the impression that others have added tables (or just views?) that have gone through schema updates. Correct?

That's what I have done. Generally, these are created by the script or the first of a set of scripts that needs them so that they are recreated on the post schema update.

Another approach that I've dabbled with is to ATTACH a database file containing my custom tables and JOIN as required. Doesn't work for VIEWs.

Nothing prevents copying custom tables out to a db and then back into a post schema update .rmtree. One would have to watch out for changes in rowids.

kevync has reacted to this post.

#3 · 2025-03-19, 12:34 pm

Tom-

Thanks for the "attach" suggestion. That's the way to go.