wurzeljena / problembase Goto Github PK

Database for mathematical problems, for Wurzel e.V.

PHP 69.34% JavaScript 15.48% CSS 10.70% PLpgSQL 4.43% Procfile 0.04%

problembase's Issues

Security vulnerability

Using the elegant snippet of code for reading in parameters opens the door to exploits. Users can overwrite variables like $_SESSION or other globals.

Hidden tags

Add the possibility to hide specific tags from unauthenticated users.

Set up working persistent connections for Postgres

We should use persistent connections for remote database scenarios. (as on Heroku)
Named prepared statements seem to get in the way of persistent connections.

Private Tags

It seems convenient to have private tags, i.e. tags which can be seen only be one user. All users should be able to create their private tags and tag every problem with them.

Graphics for solutions

Improve handling of METAPOST graphics

allow adding them
show placeholders for images in preview and let users download them
show rendered images in preview

Provide clean URLs

Use PHPs mod_rewrite to provide URLs like /task/42 instead of /task.php?id=42.

Eliminate over<head>

We have a lot of redundancy in viewable pages, because every one has its own <head>.

TeX output

Provide TeX output for certain views:

lists of problems,
single problems with solution(s),
the ordinary problem page, correctly formatted.

Keywords in solution/comments

An option to toggle searching solutions/comments for keywords would be nice.

Implement a proposing mechanism for non-editors

Non-editors could be linked to proposers via their email adress, probably via the user page (see #15). Users linked in this way could propose problems and solutions.

Translate non-math TeX to HTML for previews

For example, we should translate

line breaks \\ to <br/>
\hspace (how?)
itemize environments and \items to <ul>...</ul> and <li>...</li>
\textbf to <b>....</b> etc.
left quotes to &bdquo; and right quotes to “

Create user page

A user page might contain the form from /users/ plus their comments.

Add User Management

We have to provide mechanisms dealing with users. That includes:

a working login button,
a user management page,
show certain elements and allow certain operations only with appropriate rights.

Math tokenizer

To search the database for formulae, it would be great to have a tokenizer generating a "stemmed" canonical form. This can be done both in SQLite and PostgreSQL.

Tag management

Add a page or container to add, edit and delete tags. This includes providing a description and a color.

Allow multiple or no proposers

We have to:

change the database design
rewrite output routines properly
find a way to input multiple proposers in problem.php

create FTS table for "files",
link concerned tables by file_ids and
change related PHP - that's going to be hard.

wurzeljena / problembase Goto Github PK

problembase's People

Stargazers

Watchers

problembase's Issues

Recommend Projects

Recommend Topics

Recommend Org