What Are You Working On? - December 2014

[xxxdeath]

[QUOTE=Instant Mix;46687062]General question:

I want to start working on Java & SQL and the links between it ( JDBC ). SQL seems easy enough, but the only issue is - how do I actually create an SQL database? Would MySQL be a solution?[/QUOTE]

Yes MySQL would work, however NoSQL is a pretty awesome as well.

[Blakeguy25]

I made a dynamic polyspacial lettering system in C# for textures to be used as fonts without looking like over-spaced (or monospacial) shit :)

In the top 3 hardest things I've coded :dance:

[ECrownofFire]

[QUOTE=Instant Mix;46687062]General question:

I want to start working on Java & SQL and the links between it ( JDBC ). SQL seems easy enough, but the only issue is - how do I actually create an SQL database? Would MySQL be a solution?[/QUOTE]

Look into SQLite.

[Map in a box]

#1 rule of networked databases: if you're not using it in a server application you're using it wrong.
Enter stage left, Super Meat Boy.
Enter stage right, grading systems.

[Instant Mix]

[QUOTE=ECrownofFire;46687281]Look into SQLite.[/QUOTE]

Is that greater or worse than MySQL? So far MySQL seems to be fairly intuitive..

[Map in a box]

[QUOTE=Instant Mix;46687492]Is that greater or worse than MySQL? So far MySQL seems to be fairly intuitive..[/QUOTE]

If you want a local database use sqlite.

[reevezy67]

Turns out sqlite has a multi-thread mode. Who knew.

[Instant Mix]

Because I'm *fairly* new to this sql pish, how intensive is this on say, a raspberry pi? If I installed some linux distro onto it and used the linux binaries, would this be a performance killer or since it's local, almost be nonexistant until used?

[Nomad]

Quickly mocked up what I want to go for for the whole leveling up your AI. The progress bar determines how much time you have each day to work on each task. Hopefully I can flesh it out more tomorrow.

[vid]http://a.pomf.se/qrkwig.webm[/vid]

[mastersrp]

[QUOTE=Instant Mix;46687607]Because I'm *fairly* new to this sql pish, how intensive is this on say, a raspberry pi? If I installed some linux distro onto it and used the linux binaries, would this be a performance killer or since it's local, almost be nonexistant until used?[/QUOTE]

The latter. If you experience performance problems with SQLite3 you are probably doing something terribly wrong (such as inserting the same data more than 50.000 times). With that said, and with the fact that SQLite3 isnt the most efficient of SQL database systems, it should suffice for mostly all of the tasks that a single application would perform, or even a small forum.

It is however a good idea to keep the most basic of ideas in mind when doing SQL, regardless of performance. Normalize a billion times and so on so forth. Make sure to use efficient queries and just generally do what needs to be done.

[aehm ?]

[QUOTE=Zyx;46685857]Long time no see. I updated my Tinder bot:
[img]https://dl.dropboxusercontent.com/u/99717/TinderAutoV2.png[/img]
* Timestamps, because why not
* Automatically fetches my authentication token (From a hardcoded facebook ID)
* Checks for any new matches when I open the program
*- Writes a generic "Hello" message to any new matches
* When a new match is made, it also writes a hello message to them
* When liking people, if no more is found, it will pause and try again 10 minutes later

I can basically set it to run 1000 cycles and just let it idle all day.[/QUOTE]

Is this open source or free to use to everyone ?

[Berkin]

[QUOTE=Zyx;46685857]Long time no see. I updated my Tinder bot:
[IMG]https://dl.dropboxusercontent.com/u/99717/TinderAutoV2.png[/IMG]
* Timestamps, because why not
* Automatically fetches my authentication token (From a hardcoded facebook ID)
* Checks for any new matches when I open the program
*- Writes a generic "Hello" message to any new matches
* [B]When a new match is made, it also writes a hello message to them[/B]
* When liking people, if no more is found, it will pause and try again 10 minutes later

I can basically set it to run 1000 cycles and just let it idle all day.[/QUOTE]

If you want it to send more creative messages, I know a guy... ;)

[Winded]

Trying to do pixel art.
Here's a table
[img]https://i.imgur.com/5AKLvg4.png[/img]

[phpz]

[QUOTE=Winded;46690470]Trying to do pixel art.
Here's a table
[img]https://i.imgur.com/5AKLvg4.png[/img][/QUOTE]

That's a pretty nice billboard you made! :)

(If you want it to look like a table, you should change the lighting and if it's isometric add 2 more legs and change the table angle a bit.)

[Winded]

[QUOTE=bootv2;46690515]I like the artstyle, but at first I thought it was a signpost.
You could add some perspective and draw the back legs as well or make sure the back legs also appear in the shadow.[/QUOTE]

Yeah, the shadow wasn't quite good anyway. Maybe this looks better?
[img]https://i.imgur.com/OPFXo9T.png[/img]

[shodan]

[QUOTE=Winded;46690663]Yeah, the shadow wasn't quite good anyway. Maybe this looks better?
[img]https://i.imgur.com/OPFXo9T.png[/img][/QUOTE]

Both the original and the new one hurt my head.

[Lemmingz95]

Either the right-hand or left-hand edge of the shadow is off; both should be vertical, or both slanted.

e.g.

[img]http://i.imgur.com/qik5GFC.png[/img]

[Hng]

[t]http://i.imgur.com/YF3Hvqn.jpg[/t]

[Zyx]

[QUOTE=Berkin;46689520]If you want it to send more creative messages, I know a guy... ;)[/QUOTE]

Oh. My guy will call your guy!

[QUOTE=aehm ?;46689175]Is this open source or free to use to everyone ?[/QUOTE]

It's homemade, but I can share if you're interested.

[QUOTE=Handsome Matt;46686531]you're so adorable, I love all your posts.[/QUOTE]

Oh, stop it you..

[QUOTE=Duskling;46686528]What is the point of a tinder bot? Is it just to collect matches so that at the end of the day you can just go and see who is willing to hook up and then go down the list? Or is it just for fun?[/QUOTE]

At first, it was basically because "Why not?".
Now, it has turned into some sort of idle game, like Cookie clicker or Kitten game.

[drblah]

[QUOTE=Instant Mix;46687607]Because I'm *fairly* new to this sql pish, how intensive is this on say, a raspberry pi? If I installed some linux distro onto it and used the linux binaries, would this be a performance killer or since it's local, almost be nonexistant until used?[/QUOTE]

Don't worry about performance before it becomes a problem. I have used SQlite to process more than 700 MB of data a day on a Raspberry, using Ruby. While it was several times slower than my desktop, but it ran quite well. Took a few minutes to do large-ish updates (5 minutes for 14-20 MB), bit it was down to the slowness of the Raspberry CPU, not SQlite. On my desktop I could load the same amount of data in 5-10 seconds.
For my project, I found that SQlite was quite a bit faster than MySQL for bulk inserts/updates using a single thread. But your mileage will vary depending on what you do.

[mastersrp]

[QUOTE=drblah;46691150]Don't worry about performance before it becomes a problem. I have used SQlite to process more than 700 MB of data a day on a Raspberry, using Ruby. While it was several times slower than my desktop, but it ran quite well. Took a few minutes to do large-ish updates (5 minutes for 14-20 MB), bit it was down to the slowness of the Raspberry CPU, not SQlite. On my desktop I could load the same amount of data in 5-10 seconds.
For my project, I found that SQlite was quite a bit faster than MySQL for bulk inserts/updates using a single thread. But your mileage will vary depending on what you do.[/QUOTE]

That could've also had something to do with actually doing database shit in Ruby. That is never going to be very fast. However, you're right about it not being the fault of SQLite3. I ran a few tests on my desktop for just performance of handling simple CGI requests with a database connection in SQLite3, and my Shell script implementation was pretty close to native (C implementation), where as for instance PHP was about 10-18 times slower. Ruby is probably going to be even slower than that, but it all depends on how many times you make the different calls, and how you're doing it.

[2sp00ky]

Im working on a game inspired by smash bros and shovel knights.
[IMG]http://i.imgur.com/lqbNIUj.gif[/IMG]
[IMG]https://i.imgur.com/lQADfLc.gif[/IMG]
[IMG]https://i.imgur.com/xL4Kwpr.gif[/IMG]
Edit:
[IMG]http://i.imgur.com/jPyVuDa.gif[/IMG]

[Dilbert]

I'm attempting to convert a Doom map to Source, and to help me out, I draw out the map as I get data from it.

Here are E1M1's linedefs (red) and node partition lines (black). I tried to see if the node partition lines could help me convex polygonize the map, but it seems hard to impossible. GLBSP looks like a good option.

[img]http://puu.sh/dqqYE/89c014dcda.png[/img]

[Tommyx50]

[QUOTE=Mega1mpact;46690701]Both the original and the new one hurt my head.[/QUOTE]

I think it's because both of the back legs are "inside" the front legs, creating a reverse perspective effect, so the brain assumes that they must be in front of the front legs.

[Map in a box]

snip

[benjojo]

[QUOTE=Map in a box;46691899]Is it raiding to give a 1800 number of a malware author?
1-xxx-xxx-xxxx
[url=http://totes-maleware-domain.maleware-domain.net/mbsjsp.html]Source. Don't actually click, though[/url] Record fun havings, not sure if the number is actually active. (That site has directory listing enabled, by the way)[/QUOTE]

I would consider it raiding, in addition hrefing malware/malware domains is really irresponsible and unkind (Also can get FP SEO issues)

[Lily]

[QUOTE=Banandana;46674003][img]http://www.facepunch.com/fp/ratings/tick.png[/img] You comment your code.

[img]http://www.facepunch.com/fp/ratings/cross.png[/img] You don't comment your code.[/QUOTE]

Commenting disrupts the flow of the magic used within deep wizardry.

[Map in a box]

[QUOTE=benjojo;46692258]I would consider it raiding, in addition hrefing malware/malware domains is really irresponsible and unkind (Also can get FP SEO issues)[/QUOTE]

I didn't want to href it, but vb likes to autolink URLs. I personally don't see how it could be raiding if someones actively being malicious to see what their deal is, but i'll snip

[shodan]

[QUOTE=Tobba;46692466]Commenting disrupts the flow of the magic used within deep wizardry.[/QUOTE]

Often I comment blocks containing magic code written by unix elders on top of mnt C with stuff threatening the reader not to touch the code or else.

[kybalt]

[QUOTE=Zyx;46685857]Long time no see. I updated my Tinder bot:
[img]https://dl.dropboxusercontent.com/u/99717/TinderAutoV2.png[/img]
* Timestamps, because why not
* Automatically fetches my authentication token (From a hardcoded facebook ID)
* Checks for any new matches when I open the program
*- Writes a generic "Hello" message to any new matches
* When a new match is made, it also writes a hello message to them
* When liking people, if no more is found, it will pause and try again 10 minutes later

I can basically set it to run 1000 cycles and just let it idle all day.[/QUOTE]

Now just connect it to cleverbot. :v:

On a different note, I just realized how sad that I have to write this is

public string StationNumber;