[Noisebridge-discuss] Open Source Software for Local Gov't, i'm a Rent Board Commissioner in Berkeley looking for help

[Asa Dodsworth]

>
> The Rent Boards Budget and Personnel Committee meeting will be presented
> the revised proposal from WebMethods<http://www.softwareag.com/Corporate/products/wm/default.asp>for building a new RTS(Rent Tracking System) Database, after this meeting I
> will be able to email the group their proposal..
> their tentative date for the meeting is Monday the 28th
>
> ATTN: Attached is a City Report report issued June 29, 2009, commissioned
> by the City of Berkeley's IT Supervising Systems Analyst Keith Skinner, and
> produced by Software AG, WebMethods Report.  I posted the report here on
> MegaUpload, cause the Noisebridge list serve kept bouncing me..*
> http://www.megaupload.com/?d=NIJPNELT* (they had to send it to me with
> Gmail because the city server wouldn't allow them to upload a 7.8MB file)
> they'd probably save tons of money by migrating there email accounts to
> sites.google.com, i can send it to you with gmail if megaupload doesn't
> work for you.
>
>    - the report projects the total costs at $307K, but I believe it has
>    been tentatively negotiated down to $200K..
>    - I'm not familiar with these kinda things but this looks ridiculous to
>    me. In my naivete I imagine this could be handled by a google spreadsheet
>    and and account access controlled database viewer with a page view
>    template... Security of the information being handled by paper and pdf back
>    ups of important documents etc.
>       - one valuable feature would be to have a comment section for each
>       account with the rent board/program ex: such as this landlord has been
>       delinquent before. This can't be that complicated, this has got to be basic
>       billing and customer service software.
>
>
> *This is the feedback i've gotten so far*
>
>    - Open Source Software suggestions:
>       - a robust database like MySQL or PostgreSQL will take care of
>       keeping track of access control and replication of other databases (provided
>       you can take SQL dumps, otherwise it'll have to be the same software).
>        - PostgreSQL (if some/all of the information is not for public
>          consumption or security is otherwise a concern) or SQLite
>       - front end viewer like PHPMyAdmin (a very insecure, but functional
>       PHP app --just don't make it public on the internet), or a Django project
>       (the built-in admin console has a very simple
>       Create/Read/Update/Delete functionality for each row.
>    - requests for more info:
>    - RFP
>       - numbers of fields and records,
>       - bandwidth requirements,
>       - administrative roles,
>       - platform information such as
>       - type of host(s)
>          - operating systems
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.noisebridge.net/pipermail/noisebridge-discuss/attachments/20110324/990d1396/attachment-0003.html>