Permalink 04:10:43 pm, by mholmes, 17 words, 6 views   English (CA)
Categories: Activity log; Mins. worked: 60

Working towards faster retrieval...

...but I have a bug I can't seem to figure out in the handling of results paging.


Permalink 03:40:44 pm, by mholmes, 105 words, 10 views   English (CA)
Categories: Activity log; Mins. worked: 300

Working on the spreadsheet functionality

Spreadsheet generation is painfully slow and often runs out of memory or time. This is understandable given the number of queries taking place for complex table relationships, but I've managed to improve it substantially. I'm also working on speeding up retrieval for regular display, and I have a function written but not tested yet (db_recordList.php populateFromDb2). Ultimately, though, a massive set of joins is probably going to have to be done in the initial single query, making it absolutely huge but having it run only once, and then the non-standard db fields (lookups, one-to-manys etc.) will have to figure out parsing those results.


Permalink 05:06:55 pm, by mholmes, 77 words, 11 views   English (CA)
Categories: Activity log; Mins. worked: 90

Added "search for nothing" functionality

This has been needed for a while, and now it's essential in VPN so I've added it: you can put this into a text field:


and it will search for records which have nothing or just space in those fields.

That means the VPN folks can do that with the Images field in the Poems table and find all the records which don't have page-images; then an explanation can be added in their new Page-image notes field.


Permalink 09:13:00 pm, by mholmes, 43 words, 20 views   English (CA)
Categories: Activity log; Mins. worked: 60

Finished basic implementation of thumbnail feature

Needs a bit more documentation, and there may be a need to make the width configurable (it's set to 200px right now), but it's working for MdhLinkField and MdhLinkSetField.

More fun working on this sort of thing at home with no interruptions. :-)


Permalink 03:06:00 pm, by mholmes, 38 words, 25 views   English (CA)
Categories: Activity log; Mins. worked: 60

Started work on a thumbnail feature

Basically done for the linksetfield, although I want to add an if clause that restricts it to only links which end with image file extensions. Then I need to port the same feature to the single link field.


Permalink 03:14:32 pm, by mholmes, 35 words, 126 views   English (CA)
Categories: Activity log; Mins. worked: 45

Moved instructions into a separate include file

Minor task that's been on my todo list for ages. This makes it simpler to maintain the instructions for a specific project distinct from the base instructions. Also deleted obsolete search_instructions file and tested.


Permalink 04:49:16 pm, by mholmes, 103 words, 128 views   English (CA)
Categories: Activity log; Mins. worked: 120

Fixed bug in JSRDocs

JS-R reported a bug in the JSRDocs db, which took some time to figure out. I updated the server code to the latest version of the source, and then fixed some JS warnings, none of which was causing the problem. Eventually it turned out that there was a character 0x10 in one of the text fields; it's not allowed in XML, so it was causing Firefox to gack on any search results containing that record.

Not sure how it got in there, and not sure either how to protect against it; perhaps I need to add another component to the data sanitization code.


Permalink 04:15:13 pm, by mholmes, 48 words, 169 views   English (CA)
Categories: Activity log; Mins. worked: 120

Added a new field type: MdhDecimalField

GN's current project is storing data in decimal format, so I've added a new field type to handle this, mapping to the SQL Decimal field (which is also supported in Postgres). Updated the sandbox db and tested it -- seems to work fine -- and regenerated the documentation.


Permalink 03:17:42 pm, by mholmes, 58 words, 196 views   English (CA)
Categories: Activity log; Mins. worked: 60

Reorganized documentation system

Cleaned out any project-specific stuff (except for the sample project), removed all doxygen-generated files from SVN, and regenerated all docs, after installing all the required libraries locally. I can now generate docs OK by running doxywizard, then loading the Doxygen file and running it; to get a PDF, I switch to docs/latex and run make refman.pdf.

Permalink 02:01:00 pm, by mholmes, 135 words, 289 views   English (CA)
Categories: Activity log; Mins. worked: 60

Moved settings into separate user-controlled file

Moved the memory and timeout settings into a file called <proj/project_settings{_SAMPLE}.php> so that it can be user-controlled and set on a per-project basis. Took the opportunity to rework the JSRDocs project setup to make it more robust, for testing this rollout (it previously had only one incarnation, and no testing version):

  • Created parallel live and dev versions of the db.
  • Created live and dev code trees.
  • Wrote scripts for copying data from live to dev, and rolling out changes to dev, from dev to live local, and to dev on server.
  • Tested and backed up.

Also noticed some floating users in mySQL that had been created for testing purposes and should have been deleted. Removed them. Now watching out for any unexpected behaviour in dbs, but not expecting any.

:: Next Page >>

Adaptive Database

This project aims to design a flexible online database which can be set up as very quickly for a researcher requiring a relational database, and is easy to modify and extend. The Web GUI provides tools for data-entry in as simple and convenient a manner as possible, while also allowing data-integrity checks. The application development sandbox is currently at https://hcmc.uvic.ca/people/martin/potluck/editor/index.php; and half a dozen UVic projects are already using the codebase. The code is managed through SVN here: https://revision.tapor.uvic.ca/svn/adaptivedb/.



September 2014
Sun Mon Tue Wed Thu Fri Sat
 << <   > >>
  1 2 3 4 5 6
7 8 9 10 11 12 13
14 15 16 17 18 19 20
21 22 23 24 25 26 27
28 29 30        

XML Feeds