liquid_feedback_core

log

age author description
2014-05-22 jbe Re-added experimental "no_reverse_beat_path" feature for next minor version (provides backward compatibility)
2014-05-22 jbe Code cleanup regarding new tie-breaking
2014-05-22 jbe Implemented tie-breaking according to chapter 5 of schulze1.pdf (draft, 2 July 2012)
2014-05-21 jbe Use a composite type of two INT8's to describe the strength of a link for the Schulze method (necessary for tie-breaking of the links); Removed "no_reverse_beat_path" option
2014-04-14 jbe Generalized comment on "defeat_strength" function
2014-04-14 jbe Separate configuration options for "defeat_strength" and "tie_breaking"
2014-04-10 jbe Work on configuration of complexity of counting of the votes (extent of tie-breaking):
2014-04-05 jbe Added tag v3.0.1 for changeset 044a2b65c707
2014-04-05 jbe Added tag v2.2.6 for changeset eaba9174d117
2014-04-05 jbe Merged from v2.2.6: Marked "no_reverse_beat_path" and "no_multistage_majority" as experimental; Disabled "no_reverse_beat_path" by defaultv3.0.1
2014-04-05 jbe Marked "no_reverse_beat_path" and "no_multistage_majority" as experimental; Disabled "no_reverse_beat_path" by defaultv2.2.6
2014-03-26 jbe Bugfix for battle data reconstruction in update script
2014-03-26 jbe Reconstruct battle data in update script to avoid future data loss when executing "clean_issue" to delete voting data
2014-03-26 jbe Added update script to introduce "first_preference_votes"
2014-03-26 jbe When marking first preferences, use JOIN via "initiative" table due to missing index on "vote"."issue_id"
2014-03-26 jbe Calculation of "first_preference" votes
2014-01-31 jbe Added tag v3.0.0 for changeset 399dc1a86398
2014-01-31 jbe Marked version as v3.0.0v3.0.0
2013-12-23 jbe "schulze_rank" includes tie-breaking by "id"
2013-10-14 jbe Proportional Runoff for issues both based on single areas and single units
2013-10-14 jbe Secondary sorting key for issues in admission phase
2013-10-14 jbe core.sql: Removed "order_in_open_states"
2013-10-14 jbe lf_update_issue_order.c: Replaced occurences of "suggestion" with "issue"
2013-10-14 jbe Removed algorithm to calculate "order_in_open_states"
2013-10-14 jbe Added TODO regarding a bug in lf_update_issue_order.c
2013-10-13 jbe lf_update_issue_order.c: Insert "issue_order" rows for all issues in the area
2013-10-13 jbe Fixed syntax error in SQL command in lf_update_issue_order.c
2013-10-12 jbe Improved comments/debug output in lf_update_issue_order.c
2013-10-12 jbe lf_update_issue_order deletes stale entries in "issue_order" that may arise due to missing referential integrity
2013-10-12 jbe Remove referential integrity from "issue_order" table to avoid performance/locking issues
2013-10-11 jbe Algorithm to write "issue_order"."order_in_open_states"
2013-10-11 jbe New table "issue_order" for ordering fields to avoid a bottleneck with locking
2013-10-11 jbe Added helper view "open_issues_ordered_with_minimum_position" for lf_update_issue_order.c
2013-10-11 jbe Update script to v2.2.6
2013-10-11 jbe Always delete ordering ranks of issues (lf_update_issue_order.c)
2013-10-11 jbe Calculation of "order_in_admission_state"
2013-10-10 jbe Adjusted indentation of "issue" field comments in source code
2013-10-10 jbe Work on new issue sorting algorithm
2013-08-12 jbe Added tag v2.2.5 for changeset 992ec266356d
2013-08-11 jbe Added notice regarding PostgreSQL 9.1 requirement to update scriptv2.2.5
2013-08-11 jbe Added column "admin_notice" to "issue" table, and value 'canceled_by_admin' to "issue_state" type
2013-07-14 jbe Added tag v2.2.4 for changeset ae69cf82c05f
2013-04-20 jbe Added support for delegation checks and login recovery; Removed unnecessary join in event viewsv2.2.4
2013-03-23 jbe Added tag v2.2.3 for changeset e474e9e1240a
2013-03-23 jbe Code cleanup regarding temporary storage of session/transaction data to disable protection triggersv2.2.3
2013-03-22 jbe Added tag v2.2.2 for changeset 1c991490f075
2013-03-22 jbe Fixed an error, which occurred when deleting votes from voters, which lost their voting right during voting phasev2.2.2
2013-03-18 jbe Removed excessive space characters in lf_update_suggestion_order.c
2013-03-18 jbe Added tag v2.2.1 for changeset 0f5841ef67c6
2013-03-18 jbe Updated README file to include information on lf_update_suggestion_orderv2.2.1
2013-03-18 jbe Enable compiler optimization flags in Makefile
2013-03-18 jbe Bugfix regarding "proportional_order" of suggestions:
2013-03-18 jbe Improved log output of lf_update_suggestion_order
2013-03-18 jbe More verbose logging in lf_update_suggestion_order.c
2013-03-17 jbe Added colon in comment in lf_update.c and lf_update_suggestion_order.c
2013-03-17 jbe Optional logging in "lf_update_suggestion_order"
2013-03-17 jbe Fixed bug in while loop of "loser" function of lf_update_suggestion_order.c, that has been introduced in last commit
2013-03-17 jbe Added comments to lf_update_suggestion_order.c
2013-03-17 jbe For suggestions without individual rankings, set "proportional_order" to zero instead of NULL
2013-03-17 jbe Bugfix in "lf_update_suggestion_order" related to floating point error workaround
2013-03-17 jbe Bugfix: Numerical ordering of suggestion_id in "lf_update_suggestion_order"
2013-03-17 jbe In "lf_update_suggestion_order" take ballot weight into account
2013-03-17 jbe Bugfix in "lf_update_suggestion_order": Set candidate_count to zero, also in cases where no tuples are returned
2013-03-17 jbe Fixed errors in function "process_initiative" of "lf_update_suggestion_order", which caused memory access errors
2013-03-17 jbe Bugfix in function "process_initiative" of "lf_update_suggestion_order": Reset old_member_id to NULL
2013-03-17 jbe Added "lf_update_suggestion_order" to clean taget of makefile
2013-03-17 jbe Removed unused variable in "lf_update_suggestion_order"
2013-03-17 jbe Help output of "lf_update" and "lf_update_suggestion_order" either to stdout or stderr, depending on invocation
2013-03-17 jbe Include "final" flag in debug output of "lf_update_suggestion_order"
2013-03-17 jbe Update script to v2.2.1
2013-03-17 jbe Write "final_suggestion_order_calculated" flag in "lf_update_suggestion_order"
2013-03-17 jbe Write ranks to database in "lf_update_suggestion_order"
2013-03-17 jbe Handle out-of-memory errors in "lf_update" when escaping string literals
2013-03-17 jbe Calculation of ranks in "lf_update_suggestion_order"
2013-03-16 jbe Code cleanup in "lf_update_suggestion_order" (own block for preparation of the ballot data)
2013-03-16 jbe Free memory for candidate and ballot structure in "lf_update_suggestion_order"
2013-03-16 jbe Extended "lf_update_suggestion_order" to create a candidate structure
2013-03-16 jbe Support for proportional ordering of suggestions in core.sql; Begin of work on "lf_update_suggestion_order" (a second background job for sorting suggestions based on a proportional preferential voting system)
2013-03-10 jbe Added tag v2.2.0 for changeset 49c25dbc27bc
2013-03-10 jbe Added reminder to make backups before installing updatesv2.2.0
2013-03-09 jbe Bugfix for calculation of harmonic_weight, when there are initiatives without supporters
2013-03-09 jbe Updated LICENSE file
2013-02-21 jbe Execute update script from v2.1.0 to v2.2.0 in isolation level REPEATABLE READ
2013-02-21 jbe Set harmonic_weight for all issues in update script to v2.2.0
2013-02-21 jbe Compatibility for PostgreSQL 8.4 in lf_update.c
2013-02-21 jbe Added comments for functions "require_transaction_isolation"() and "dont_require_transaction_isolation"()
2013-02-21 jbe Changed indentation in "check_issue" function code
2013-02-21 jbe Removed unnecessary code, because multiple phase changes at once are no longer possible
2013-02-21 jbe Write "NOW()" as "now()"
2013-02-21 jbe Code formatting of constraint "valid_state" in table "issue"
2013-02-21 jbe Update script to v2.2.0
2013-02-21 jbe Removed setting of "ranks_available" column in function "clean_issue"
2013-02-20 jbe Removed deprecated timeline views
2013-02-20 jbe Cleanup of new code for allowing "lf_update" to run without extensive locking
2013-02-19 jbe Removed debug code in lf_update.c
2013-02-19 jbe Use different transaction isolation levels in "lf_update" program
2013-02-15 jbe Completely removed table locking in favor of transaction isolation requirements
2013-02-15 jbe Bugfixes for new system to allow the background job (lf_update) run without intensive locking
2013-02-14 jbe Work on new system to allow the background job (lf_update) run without intensive locking (incomplete yet)
2013-02-11 jbe Removed locking system
2013-02-10 jbe Added comment in "clean_issue" function
2013-02-10 jbe Stub (no implementation yet) for "phase_finished" field, allowing calculations to take more time without database locking
2013-02-10 jbe Correct index usage when calculating "harmonic_weight"
2013-02-10 jbe merge
2013-02-10 jbe Bugfix regarding index usage (speeds up lf_update)
2013-02-10 jbe Removed update script to v2.1.1 due to upcoming major changes
2013-02-09 jbe Removed "harmonic_weight" for suggestions, because another proportional ranking algorithm is needed there
2013-02-08 jbe Calculate "harmonc_weight" after all other calculations in an issue (as calculation depends on the "admitted" flag now)
2013-02-08 jbe Require "satisfied" support for "admitted" initiatives when calculating "harmonic_weight"
2013-02-08 jbe Calculate "harmonic_weight" to be used as a secondary sorting key, while the "admitted" flag shall be used as the primary sorting key for initiatives
2013-02-02 jbe Bugfix in view "remaining_harmonic_suggestion_weight_summands"
2013-02-02 jbe Bugfix in view "remaining_harmonic_opinion_weight"
2013-02-02 jbe Count non-fulfilled suggestions with positive opinion and fulfilled suggestions with negative opinion for "harmonic_weight" of suggestions
2013-02-02 jbe Set "harmonic_weight" to zero instead of null, where there are no supporters
2013-02-01 jbe Update script for "harmonic_weight" feature
2013-02-01 jbe Minor fix in comment
2013-02-01 jbe Changed rounding behaviour for "harmonic_weight"
2013-02-01 jbe Added "harmonic_weight" for suggestions; Bugfix in function "set_harmonic_initiative_weights" (clear weights prior calculation)
2013-02-01 jbe Removed debug notice in function "set_harmonic_initiative_weights"
2013-02-01 jbe "harmonic_weight" for initiatives
2012-10-15 jbe Added tag v2.1.0 for changeset 5c98265b39a0
2012-10-06 jbe Added missing DROP FUNCTION "vote_ratio" in update scriptsv2.1.0
2012-10-05 jbe Merged fix from v2.0.12: Removed unwanted (and broken) tie-breaking by approval rate
2012-10-05 jbe Added tag v2.0.12 for changeset a839e7efde9f
2012-10-05 jbe Removed unwanted (and broken) tie-breaking by approval ratev2.0.12
2012-09-30 jbe Removed broken tie-breaking implementation
2012-09-30 jbe Added TODO for broken implementation of tie-breaking
2012-09-29 jbe Better tie-breaking
2012-09-25 jbe merge: Switched order of row-level and table-level member locking
2012-09-25 jbe Switched order of row-level and table-level member locking
2012-09-25 jbe merge: In function "lock_issue"("issue"."id"): Instead of accquiring a table-level EXCLUSIVE lock, use a table-level SHARE lock in combination with row-level SHARE locks
2012-09-25 jbe In function "lock_issue"("issue"."id"): Instead of accquiring a table-level EXCLUSIVE lock, use a table-level SHARE lock in combination with row-level share locks
2012-09-25 jbe Different locking levels and different locking order in function "lock_issue"("issue"."id") to avoid deadlocks
2012-09-24 jbe Use SHARE MODE table locks in function "lock_issue"("issue"."id") for tables neither referenced nor changed
2012-09-13 jbe Use EXCLUSIVE MODE table locks in function "lock_issue"("issue"."id")
2012-08-26 jbe Correctly transform existing "contingent" entries when updating to v2.1.0
2012-08-25 jbe Split contingent into polling and non-polling contingent
2012-08-20 jbe No "issue_quorum" for polling policies
2012-08-20 jbe Issues may have an admission_time set to NULL
2012-08-19 jbe Modified function "forbid_changes_on_closed_issue_trigger" to allow voting comments to be changed after voting has finished
2012-08-19 jbe Updated comments for polling mode in core.sql and core-update.v2.0.11-v2.1.0.sql
2012-08-19 jbe Changed order of "close_voting" and "clean_issue" functions in update/core-update.v2.0.11-v2.1.0.sql
2012-08-19 jbe Commented update/core-update.v2.0.11-v2.1.0.sql
2012-08-19 jbe Deprecated old API tables in update script update/core-update.v2.0.11-v2.1.0.sql
2012-08-19 jbe Moved voting comment to table "direct_voter"
2012-08-19 jbe "non_voter" deletes "direct_voter" and vice versa
2012-08-19 jbe Included changed comment on function "delete_private_data"() in core-update.v2.0.11-v2.1.0.sql
2012-08-19 jbe Removed preliminary API tables for upcoming release (will be included later)
2012-08-15 jbe URL for registered (web) API clients
2012-08-15 jbe Unique "client_identifier" for "registered_client", No foreign key in table "authorized_client"
2012-08-15 jbe Work on tables for OAuth2
2012-08-10 jbe Included old API tables maked as "deprecated" to allow testing with alpha api and preliminary authorization interface after core update to v2.1
2012-08-10 jbe Marked API tables as preliminary
2012-08-10 jbe Added field "code_grant_multiple" to "api_client"
2012-08-09 jbe Renamed "token_grant" to "implicit_grant" and fixed comments
2012-08-09 jbe Notice in README file about "delete_private_data"() function
2012-08-09 jbe Hint in function "delete_private_data" for cases where different data shall be deleted
2012-08-09 jbe Changed comments in table "api_client" to specify that certain values are maximum values
2012-08-09 jbe Work on OAuth2
2012-08-08 jbe Removed "parallel_access" flag from API tables; Copy access_level and validity_period to table "api_access"
2012-08-08 jbe Added "parallel_access" and "old_refresh_token" to API tables
2012-08-08 jbe API client name not unique; Use OAuth2 client identifier as redirection endpoint
2012-08-08 jbe Work on OAuth 2.0 authorization support
2012-08-08 jbe API system clients and redundancy in API access table
2012-08-08 jbe Draft for OAuth 2.0 authorization support
2012-08-07 jbe Changed Makefile: Placed argument for the linked library after the source file that uses its symbols
2012-07-15 jbe For "polling" policies "admission_time" is always NULL
2012-07-15 jbe Added update/core-update.v2.0.11-v2.1.0.sql
2012-07-15 jbe Polling mode
2012-07-15 jbe Policies with "free_timing"
2012-07-15 jbe Removed "issue_comment"
2012-06-20 jbe Updated LICENSE file
2012-06-20 jbe Added tag v2.0.11 for changeset e818f83e133b
2012-06-20 jbe Added update script from v2.0.10 to v2.0.11v2.0.11
2012-06-20 jbe Simulation of default delegation in functions "delegation_chain" and "delegation_info"
2012-06-15 jbe Added tag v2.0.10 for changeset 389200fd973d
2012-05-20 jbe Added field "participating_member_id" to result of "delegation_info" functionv2.0.10
2012-05-15 jbe Added tag v2.0.9 for changeset 5ee7eed2f5b0
2012-05-15 jbe Updated README file, noting that data import after updating has to be done as database superuserv2.0.9
2012-05-15 jbe Allow "calculate_ranks" to work properly, even if there was a previous counting of votes (due to manual reset of issue state)
2012-05-14 jbe Bugfix in core-update.v1.4.0-v2.0.0.sql: Explicitly drop NOT NULL constraint of columns winning/losing_initiative_id
2012-05-12 jbe Bugfix in view "unit_member_count"
2012-05-11 jbe Function "delegation_info": Do not set "other_trustee_id" when overriden by previous participation
2012-05-10 jbe Backported fix of future version to update script to v2.0.0 to be able to include unused invite codes in member table
2012-05-10 jbe Fixed update script from v1.4.0 to v2.0.0: Keep unused invite codes
2012-05-10 jbe Update script to v2.0.9
2012-05-10 jbe Comments on delegation information functions
2012-05-10 jbe Support closed issues in "delegation_chain" function; Work on "delegation_info" function
2012-05-10 jbe Function "delegation_chain" returns unknown participation for other members during voting
2012-05-10 jbe New function "delegation_info"
2012-03-15 jbe Added tag v2.0.8 for changeset fefc15eb747b
2012-03-15 jbe Bugfix: Delete member fields "lang", "notify_level" and "formatting_engine" in function "delete_private_data"; Update script to v2.0.8v2.0.8
2012-03-13 jbe Added tag v2.0.7 for changeset 4346d48b1780
2012-03-13 jbe Update script to v2.0.7v2.0.7
2012-03-13 jbe Delete sessions:
2012-03-11 jbe Added tag v2.0.6 for changeset f022016f6748
2012-03-11 jbe Update script to v2.0.6v2.0.6
2012-03-10 jbe Added column "invite_code_expiry" to table "member"
2012-03-10 jbe Bugfix in function "write_event_initiative_revoked_trigger": Set "draft_id" in "event" table
2012-03-05 jbe Bugfix: Do not write history entries for non-activated members
2012-03-05 jbe Added tag v2.0.5 for changeset 6e273a6ed235
2012-03-05 jbe Delete "admin_comment" in function "delete_private_data"; Update script for v2.0.5v2.0.5
2012-03-01 jbe Added tag v2.0.4 for changeset 10a231cfd585
2012-02-28 jbe Delete non-activated members in function "delete_private_data"v2.0.4
2012-02-28 jbe No generic NOT NULL constraints on columns "name" and "notify_level" in table "member"
2012-02-25 jbe Update script for v2.0.4
2012-02-25 jbe Added index on "event"."occurrence"
2012-02-25 jbe Changes in event system:
2012-02-25 jbe Added column "lang" to table "member"
2012-02-25 jbe Re-added "session" table to the core
2012-02-22 jbe Added tag v2.0.3 for changeset 2571bb3bdf56
2012-02-22 jbe Update script to v2.0.3v2.0.3
2012-02-22 jbe Change in "rank" order of admitted initiatives:
2012-02-22 jbe Bugfix: Set "eligible" to FALSE for all non-eligible admitted initiatives
2012-02-17 jbe Added tag v2.0.2 for changeset 919d16c8e8e3
2012-02-17 jbe Added new column "authentication to table "member"; Added update script to v2.0.2v2.0.2
2012-01-29 jbe Added tag v2.0.1 for changeset c23b288fd771
2012-01-28 jbe Fixed comment on column "unit"."active"; Cleanup and documentation of update script from v2.0.0 to v2.0.1v2.0.1
2012-01-21 jbe Update script from v2.0.0 to v2.0.1
2011-12-27 jbe Minor fixes in initiative comments
2011-11-14 jbe merge
2011-10-23 Lars Winterfeld fix init.sql
2011-11-14 jbe Clarified comments, added warnings in comments about correct usage of indicies
2011-11-14 jbe Use "invite_code" column instead of "invite_code" table in function "delete_private_data"
2011-10-24 jbe Bugfix in old update scripts from v1.3.1 to v1.4.0: Set default of "issue"."state" to 'admission'
2011-10-08 jbe Added column "draft_id" to table "direct_supporter_snapshot"
2011-10-08 jbe Added table "unit_setting"
2011-10-06 jbe Changed README file to explicitly explain that lf_update needs to be called via cron or similar
2011-09-11 jbe merged retagging of v1.4.0
2011-09-11 jbe Added tag v1.4.0 for changeset 859d82b14c38
2011-09-11 jbe Added missing core-update.v1.4.0_rc4-v1.4.0.sql file for v1.4.0v1.4.0
2011-09-11 jbe Added tag v2.0.0 for changeset e8c6035b03f3
2011-09-10 jbe mergev2.0.0
2011-09-10 jbe Added tag v1.4.0 for changeset d53e276f32ba
2011-09-10 jbe Changed version 1.4.0_rc4 to 1.4.0 in core.sql
2011-09-10 jbe v1.4.0_rc4 gets v1.4.0
2011-09-10 jbe Renamed v1.5.0 to v2.0.0
2011-09-04 jbe Created new demo.sql with basic settings and units and areas for an imaginary "Solar System" installation
2011-09-04 jbe Renamed demo.sql to test.sql
2011-07-30 jbe UNIQUE constraint for "member_application"."key"

Impressum / About Us