Talk:Student projects/SQLite
From MoodleDocs
[12:57:16] andreibautu says: I've read the info from the links you send me. [12:57:21] Penny Leach says: yep [12:57:30] Penny Leach says: and you were in the second developer meeting I think with Petr and Eloy [12:57:39] andreibautu says: the new db layer looks very nice [12:57:46] andreibautu says: yes, but I missed the next one. [12:57:51] Penny Leach says: ah that's probably ok [12:57:58] Penny Leach says: I missed it too, I was getting ready for my move [12:58:05] Penny Leach says: by the one you had I think most things have become final [12:58:11] Penny Leach says: and landed in cvs HEAD as well. [12:58:32] Penny Leach says: I think there is another one Monday morning that I will also miss, I will be driving back from munich then [12:58:38] andreibautu says: will the XMLDB change also? [12:58:47] Penny Leach says: yes [12:58:51] andreibautu says: I'll catch that one. [12:58:52] Penny Leach says: eloy has been updating the bug [12:59:18] Penny Leach says: just trying to find it [12:59:19] andreibautu says: including the schema of the xml files? [12:59:24] Penny Leach says: no [12:59:24] Penny Leach says: not schema [12:59:34] andreibautu says: only the implementation, then. [13:00:11] Penny Leach says: http://tracker.moodle.org/browse/MDL-14863 [13:00:38] andreibautu says: did you look at the project's wiki page? it looks kind of empty to me, but I don't know what else should go there. any suggestions? [13:00:43] Penny Leach says: I did look [13:00:46] Penny Leach says: I asked Petr to look also [13:01:49] Penny Leach says: I think it's ok , you're right it isn't that long but I don't think the sqlite subclass is that complex and probably doesn't need further specification - what I think *does* need more specification before you start coding is the translation between different database types. you can use xmldb schema for the schema but what about the data ? [13:02:00] Penny Leach says: and also it would be good to get a feel for the UI for translating between databases [13:02:49] andreibautu says: a UI mockup? [13:03:08] Penny Leach says: not necessarily that much unless you want to.. probably just a description of screens and what will be on them and what if any options [13:03:21] andreibautu says: aha. [13:03:22] Penny Leach says: and also where the code functions are for export/import [13:04:29] andreibautu says: I was thinking to make it look like the UI of the database step in moodle's install. [13:04:36] Penny Leach says: ah ah. [13:04:39] Penny Leach says: ah ha, even [13:04:41] Penny Leach says: sounds ok to me [13:04:52] andreibautu says: will it require more options than that? [13:05:02] Penny Leach says: I'm not sure [13:05:06] Penny Leach says: maybe exclude logs [13:05:14] Penny Leach says: option, I mean [13:05:18] andreibautu says: yes. that could be. [13:05:26] Penny Leach says: have you been through moodle's backup and restore function? it asks to exclude logs because they're big [13:05:41] andreibautu says: yes. [13:05:47] andreibautu says: I've used them. [13:05:50] Penny Leach says: another thing is... if this is used to transfer data between databases and potentially servres [13:05:51] Penny Leach says: servers [13:06:13] Penny Leach says: you need to remember that files need to shift too - you could print a message saying "make sure if you are shifting this to another server to include the data directory" [13:06:31] Penny Leach says: oh and if you're transferring *into* postgres, you need to make sure you reset sequences to their proper value [13:06:39] Penny Leach says: at the end [13:06:42] Penny Leach says: similar to what a pgdump does [13:06:44] Penny Leach says: not sure about the others [13:06:56] Penny Leach says: probably not mysql but don't know about oracle and mssql - that'll need some research [13:07:15] Penny Leach says: eloy can probably help there, I don't know about proprietary databases. [13:07:22] Penny Leach says: I would think you'd need to with oracle. [13:07:25] andreibautu says: should this tool allow transfer betweem servers? [13:07:45] andreibautu says: I was thinking to have the same installation but switch only the database. [13:07:55] Penny Leach says: well, if you're allowing transferring data between database types people could potentially use it for moving to another server as well. [13:07:58] Penny Leach says: hm. [13:08:02] Penny Leach says: yes [13:08:05] Penny Leach says: if you're moving to a test server, for example [13:08:09] Penny Leach says: which was the original case for using sqlite [13:08:20] Penny Leach says: I could use this to backup my production site and then restore on my workstation to debug [13:08:21] andreibautu says: ok. I'll check on that. [13:08:36] andreibautu says: but then the links in the content might get broken. [13:08:53] Penny Leach says: what do you mean ? [13:08:57] Penny Leach says: it would have the same ids [13:09:13] Penny Leach says: you would have to insert everything using hte same ids as originally have and then push the sequence out to the end [13:09:17] andreibautu says: I'm refering to the HTML links. [13:09:18] Penny Leach says: rather than re-keying everything [13:09:28] Penny Leach says: oh well that's the same problem as if the domain changes [13:09:41] Penny Leach says: people should be using relative links anyway [13:09:43] Penny Leach says: hm. but [13:09:48] Penny Leach says: backup and restore rewrites urls [13:10:23] andreibautu says: htmlarea does not uses relative urls. [13:10:31] Penny Leach says: yes, I think they get rewritten [13:10:47] andreibautu says: I had to make some hacks to have our installations function properly. [13:11:13] andreibautu says: ok. I'll take a closer look at the backup/restore tools. [13:11:17] Penny Leach says: I think that at the point you try and point moodle at one of these files ( I think you would have to do this during installation step ) it'll know its new url and check to see if its the same and rewrite some content before restoring into new database [13:11:27] Penny Leach says: which means you would add a manifest to the export files [13:11:31] andreibautu says: they seem to have lots of usefull tips for me ;) [13:11:46] Penny Leach says: manifest + xml schema + data = moodle content transfer [13:12:08] Penny Leach says: the manifest should contain some data about the original environment like moodle version maybe and original database type and also base url. [13:12:16] Penny Leach says: this is the sort of thing we should be specifying ont he wiki page. [13:12:36] Penny Leach says: I think maybe attaching the log of the skype chat would help :) [13:13:05] andreibautu says: ok. I'll save it :) [13:13:23] Penny Leach says: hopefully this gives you a good starting point to write the specification for this part [13:13:31] Penny Leach says: I think this is harder and more fuzzy than the sqlite part. [13:13:33] andreibautu says: yes. it does. [13:13:46] Penny Leach says: but also we will be doing the sqlite part first while this can be further fleshed out [13:13:51] andreibautu says: yes. it looks like for now. [13:13:55] Penny Leach says: but getting as much as possible spec'd by the 26th is good [13:13:55] Penny Leach says: :) [13:15:05] andreibautu says: does moodle in head uses the new dblayer now? [13:15:17] Penny Leach says: yes [13:15:19] Penny Leach says: oh [13:15:20] Penny Leach says: use [13:15:28] Penny Leach says: not sure if the switchover is done, but the new libraries are in place [13:15:49] andreibautu says: yes, I see.