Difference between revisions of "Talk:Student projects/SQLite"

Jump to: navigation, search

Note: You are currently viewing documentation for Moodle 2.0. Up-to-date documentation for the latest stable version is available here: Student projects/SQLite.

(Shifted to dev docs)
Line 1: Line 1:
<pre>[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.</pre>

Latest revision as of 05:45, 15 September 2011

This development related page is now located in the Dev docs.

See the Talk:Student projects/SQLite page in the Dev docs.