[Insight] [Resource] A Different way to use SQL Queries/ResultSets

A Few days ago i started working on my FriendZone plugin, and i realized that this will cause the server to constantly lag whenever a query is made to the sql database. So i decided to go with a Threaded Querying system.

This Threaded Querying system (from the few times i have tested it) seems to not interfere with the servers performance. This is pretty neat because well, not many plugins that use sql do this and it tends to slow the server down when there is a large volume of data present.

Another thing i decided to do with FriendZone is add a sort of Caching system, this system stores all data in the sql database inside the plugin. This Caching system makes it possible for FriendZone to only query the sql for ResultSets once for every table that FriendZone uses. Well how is that possible?

Since, i think doing something like this can benefit all (if not most) plugins and developers that use SQL; I decided that i wanted to share the work with you.

Threaded Querying System --> https://gist.github.com/Goblom/9099566

Code:java

Database db = new Database();
 
db.setSystem(new Database.System() {
  public Connection connect() {
      // Load Drivers and such
      return connection_made;
  }
});
 
db.update("INSERT INTO `example_table` ('id','username','online') VALUES ('NULL','Goblom','true');");
 
db.query("SELECT * FROM `example_table`", new Database.QueryHandler() {
  public void onDataRecieveEvent(DataRecieveEvent event) {
      // Do stuff with Result Set
      // event.getResult();
  }
});

Caching System.... --> https://gist.github.com/Goblom/9100329