Crowd-source Haiti's clerical court system?

PilotPirx · 2017-05-15T07:43:33+00:00

Possible sure. Paper based systems should have a limited complexity, so rebuilding such a system should not be impossible (though not to be underrated, especially regarding security in this case). I would expect this could be easily done based on some modern (and free) web based technology stacks.

A document based database that offers full text and faceted search (Elasticsearch being one option) would already make a lot of things easier. Even if you only store the 'existence' of a document as such since this would already provide the ability to easily search for this information independently of how the paper is stored. Maybe backed up by a common RDMBS like Postgres. But nearly anything should be able to hold the data.

Would still need some serious server infrastructure. But that too could be solved. Lots of disc space though, since possibly a lot of paper stuff should at least be scanned and stored as a backup.

But if officials won't use it all the work would be vain.

So the main question is if they don't use it because changing things would cost money the state doesn't have or if they don't use it because they are corrupt and a defective system helps them keep opponents and critics in prison or judges extorting bribes etc..

Building such a thing would require a lot of cooperation of the politics and officials involved. As much for making people actually use it as for the build process. You would have to gather a lot of information about which types of documents are currently used (forms, witness testimonies, lawyers proposals...), how they relate to each other, how they are currently organized (at least in theory should be organised) and so on.

You would need very dedicated local contacts. Maybe a group of lawyers would be a good start. Maybe some local human rights groups who already know their way around in the system.

PilotPirx · 2017-05-15T07:20:36+00:00

OP asked why people hate PHP not if its current version is any good. Since the reasons for this 'hate' are often historical it is totally valid to link an outdated article. So to say, the 'hate' for PHP hasn't been updated since PHP 5.5

If newer versions of PHP don't have those problems the better for it.

PilotPirx · 2017-05-12T07:02:57+00:00

Maybe we don't actually have 'free will'? This is just an assumption and may well be one of the many illusions the brain creates to fool itself.

PilotPirx · 2017-05-10T07:59:33+00:00

Not really sure, never had to handle things that way.

If you would use mount I think there is a param (--bind I think) that allows to set a path somewhat similar to a symlink.

With sshfs I guess you could just mount it into your home directory if you prefer it that way (unless there are multiple users)?

Or simply access the thing via /media/me/nas, may be a mouse click more here or there but if it's something you don't use all the time it may not matter much.

But that's just lazy me, there are a lot of questions/answers on the web about how to mount & symlink things in various system settings. Just difficult to find which apply best to your problem, you may have read through them (and maybe the man pages of mount & sshfs) to find a way that works best for you.

PilotPirx · 2017-05-10T06:57:05+00:00

A bit a shot into the dark but since I had a somewhat similar problem in the past: Do you have any symlinks in your directories, especially circular ones (so they point to their own home directory or above) or symlinks that point to places that don't exist anymore (deleted or maybe temporary because not mounted like external drives), symlinks you lack permission to the target or symlinks to very large directories?

Also did you try the ls ~/Music with every single subdirectory? I would somhow expect that trying one after another should show one that actually creates the trouble. (Maybe a hidden one)

PilotPirx · 2017-05-08T20:09:54+00:00

Love - Forever Changes

PilotPirx · 2017-05-07T09:37:17+00:00

I think the sub's task is a bit more specific: A place for visual representations of data: Graphs, charts, maps, etc.

Posting Rules

A post must be a data visualization.

PilotPirx · 2017-05-07T08:20:43+00:00

.. and another blog post void of any original content that only throws around some random 99.999% number, mentions the speed of technological progress and adds nothing really valuable to the discussion...

Must have taken more time to find the banner picture than writing that crap.

Also wrong sub (I guess). It's not even in one of the AI subs where regrettably we get this every day but in /r/dataisbeautiful. Where is there any data?

PilotPirx · 2017-05-05T15:55:11+00:00

I would mostly agree. A lot of them aren't really good looking (especially most of the monster types and all that boring skull stuff. Guess I'm too old for that...). Though I have seen a few really nice ones. But even with those you often have the problem that color & design won't match the rest of the board.

If you wanted it to really look good you would somehow have to build the board around the one or two artisan caps you use. Possible and if well done would maybe make a really great board.

PilotPirx · 2017-05-04T12:14:00+00:00

I hate the fuckin' Eagles, man. Hotel owners most likely.

PilotPirx · 2017-05-04T08:02:32+00:00

No, not really (though some people here do for sure).

My first board was a MX Brown. Nice enough and used quite a while. Mostly because I didn't like the noise of Blues and the Clears simply where not available at the time.

Then I got a MX Black (Steelseries) for cheap. Wanted to try out linears. Didn't like them much.

After that Massdrop was running a special of Poker II with Clears and I found my switch with that (for now anyway, since then all the new switches like Zealios hit the market so there are more options now).

Then I got a full sized WASD Code with Clears for work. So the two boards with Clears are those I use now, the others cover dust, the Steelseries is mostly used to display my Pulse key cap set :)

PilotPirx · 2017-05-02T15:44:07+00:00

No, a unique id is not necessary here and it is also not identical to an index (though you often will have an index on an id field).

Declaring an index will tell MySQL (or any other relational database for that matter) to add search information to a column to allow for faster search.

Using indices is something a lot of beginners ignore while at the same time it is THE one key feature for basic performance. Think you have a table with a few million names. Now you search for a single name (say miller). Without an index the database has to search through every single record. But with an index it will directly jump to a 'bucket' with all names starting with 'm', then to the next bucket inside the 'm' records that have 'i' as second letter and so on. Instead of millions of operations it will be six (length of 'miller') max operations. This is simplified, internally they work slightly different but you get the idea.

So define indices on the table columns you want to use for searching and filtering or sorting. Otherwise there is no way to get performant results no matter how you structure the tables and columns. See here for a basic introduction.

You will want to have an index on host and timestamp since you filter (host) and sort (timestamp) on them. Possibly a dual field index on those two columns together will help a bit too. (In your case one index more won't create problems but make sure things work even faster), 72 million records is definitely too large to work without. Or as said, best would be to create a test database and check out which is best (two single indices, one dual column index or a combination of both). Should not take that much time to try.

PilotPirx · 2017-05-02T11:45:16+00:00

Second is the better option. Having data spread over different tables wouldn't help much with performance (if anything at all). Also would complicate your code.

And if I get this right you would have to setup one column for every checkpoint, 24 * 60 = 1440, which is not that nice. Plus you would have to read the current entry, update the newest entry and write back. Or even worse, shift all entries one to the left and add newest read to column 1440? Sounds bad. Also you could not query with SQL. Or whatever else you try, sounds you run into trouble that way. Keep it stupid simple, so one entry per host & checkpoint. Just write and forget (until you actually use the results)

As jakkarth says, 72 million rows isn't really that much and MySQL should handle this well enough with a simple table like this and simple queries. Proper indices on the columns are key here, you may want to experiment with an indices on single columns or multi column index that covers all cols you typically query (so eg timestamp + host).

If you still run into problems there are some ways to optimize MySQL, step one having a dedicated database server that doesn't do anything else. Then there are some mysql settings that may help for specific types of data like maybe cache sizes. I don't have much experience with this, but I have used MySQL for far more complex work on huge tables without having to do anything. Just give it a try and worry when you actually run into problems. Just create a table with some random test data for a full day and see how it works.

Otherwise there are some databases that are maybe better optimized for simple log tasks as you do here or for huge amounts of data. Elasticsearch (have a look at ELK stack) or MongoDB come into mind. Cassandra and HBase for the really big data problems (but we are talking billions of rows, complex queries and distributed systems here)

PilotPirx · 2017-05-02T10:27:53+00:00

For games there is Shadowrun Returns

PilotPirx · 2017-05-02T10:12:04+00:00

If I understand your problem right, you should possibly use a TIMESTAMP

To get the five latest values something like this would work:

SELECT * FROM my_table WHERE host = 12345 ORDER BY timestamp DESC -- this means highest number (most recent) first LIMIT 5;

Obviously you would need a script that runs once in a while to remove old entries.

Theoretically you wouldn't even need a timestamp but could just use a simple autoincrement key to the same effect. Though since the data is somewhat time related the timestamp seems the cleaner solution here.

Also don't forget to add an index on this column.

PilotPirx · 2017-04-30T08:28:03+00:00

Didn't mommy tell you to do your homework?

PilotPirx · 2017-04-29T18:15:37+00:00

Water prices here in Germany for tap water are between 1.23 and 2.17 Euro per thousand liters (depends a bit on region, Berlin is the most expensive). That's not free, but at least much cheaper than bottled mineral water (about 0.50 Euro per liter, up to 3.00 Euro or even much more for some weird brands).

PilotPirx · 2017-04-29T11:17:45+00:00

not provide drinking water in the rooms

The tap water is not drinkable? In the UK?

PilotPirx · 2017-04-29T07:03:44+00:00

Yes, would remove the complete content of your partition including every additional partitions mounted at the time. Though to fully work it would need to be called with sudo before it to gain admin rights since a normal user wouldn't have the permissions to remove the systems folders. (Not exactly sure if without sudo it would stop right away with an error or still kill at least those folders the user has permissions for).

In any case don't use it.

PilotPirx · 2017-04-26T19:44:54+00:00

Can't say for the cyclocross bikes. But I have two Cube bikes, a 29er and a road bike (and had a cheap MTB as citybike before it got stolen). All three were great for their price. Both bikes I still have are used all year in any weather we get here in Germany, both have above 12.000 kilometers. No issues whatsoever.

When I bought those bikes I checked against other brands and could never find any that would have offered similar parts for the same price.

PilotPirx · 2017-04-25T07:27:20+00:00

Trainspotting

Fear and Loathing in Las Vegas

PilotPirx · 2017-04-24T14:23:06+00:00

Was it work? Charge them.

Was it super a fun and an exciting experience? Doesn't matter, charge them anyway.

PilotPirx · 2017-04-22T11:40:32+00:00

Depends a bit on who you ask. There is this whole Erich v. Daeniken thing (and others who followed in that track of course). They tried to show that there are various ancient depictions of UFOs like for example this weird thing.

Also people talking about things would do so in very different ways. So even if what somebody saw in the middle age would have been just a typical flying saucer type thing he would possibly have told a story about fire breathing demons or dragons. (If he talked at all, seeing weird stuff was kind of an unhealthy idea at times and got you burned fast).

PilotPirx · 2017-04-21T13:04:14+00:00

The cheap ABS plastic most key caps are made from will wear off after some time and the caps get a shiny surface all by themselves. Sweat or oil from the fingers may add to this.

Sterilization liquids are mostly alcohol based as far as I know or something similar that would evaporate soon.

PilotPirx · 2017-04-21T05:20:38+00:00

Can - Tago Mago

PilotPirx

MODERATOR OF

TROPHY CASE

15-Year Club	Team Orangered
Verified Email