Description

Version 3.2 is out, be sure to read the changes section

GMSDB is a database system written entirely in GML that can be used in any kind of project requiring a simple solution to store and retrieve organized data.

With GMSDB you can easily perform basic CRUD (create,read,update,delete) operations on a database table while applying custom filters, sorting, limits, offsets, calculations and joins on the result set.

FEATURES

  • All in GML, doesn't require any external DLLs etc.
  • Comprehensive and flexible query system
  • Ability to sort, filter, limit, offset and join your query result
  • Load and save the whole database or specific table to file
  • Import and export table data from and to CSV file to be used with excel
  • Well commented code and extensive documentation
  • Get started with the included examples showing how to build a simple highscore and inventory system
  • Includes some useful generic CSV parsing scripts

LINKS

Documentation and install guide

Download demo

Forum topic

My assets: FormLESS (UI framework), GMGL (autoupdater & launcher), Autotiles Helper (auto tiling system), Jade UI (UI sprites)

End User Licence Agreement (EULA).

Changes in 3.2.1

3.2.1: Fixed JSDoc script declarations.

Version 3.2 changes a lot of functions related to the database saving system, and a few functions have been renamed or removed.

Be sure to read the section about upgrading from 3.1 to 3.2 in the documentation. You will also find a list of every other change introduced in version 3.2

Version 3.2.1. Published March 12, 2017

Age Rating: 4+

Average Rating

Your review

You can only review assets you've bought.


Gravatar

Johan L 11 March 2017

Truly the best database system for your game!

This review was left for a previous version of this asset.


Gravatar

David H 10 March 2017

This review was left for a previous version of this asset.


Gravatar

Roelf M 09 June 2016

This is Truly The Best DB Solution

This is a really good DB solution for game maker studio.I have been searching google for DB tutorials for GMS and only found 1 which didnt really work.But this worked perfectly for my rpg login,inventory,shops,Claimed lands etc etc.Thank you very much

This review was left for a previous version of this asset.


Gravatar

Austen L 25 May 2016

Fantastic and powerful

This covers one of Game Maker's major weaknesses. Like Glen H says below, the sheer number of things you can do can be overwhelming (if you're not terribly experienced with databases, like I am, it takes a lot of getting used to), but the documentation is thorough and high quality. If you have a large amount of information to manage in your game, you're handicapping yourself by not using this package.

Its biggest weakness may well be that you need a GM:S pro license to buy it. Unless YoYo adds a native database system, this will be in my back pocket for a long time.

This review was left for a previous version of this asset.


Gravatar

Glen H 05 May 2016

I really like this, but it can be overhwelming.

It's very smooth. Although, I find it a bit difficult to go through all the scripts and make edits where I need to make it fit my requirements. I did not expect there to be so many scripts to make this engine run. You put a lot of work into it. I'm going to need help getting what I want out of it though. I sent you an email with more details on what I would like to accomplish with these scripts.

This review was left for a previous version of this asset.

Logo

Homunculus (Publisher) 06 May 2016

Hi Glen, I'm aware that the system is heavy in scripts and overall code, and that's why I dedicated a lot of time writing the documentation.
The idea though is that you shouldn't need to change nor understand the scripts at all, but just use them, since it's a multipurpose database. Feel free to contact me for more info.


Gravatar

M G 28 April 2016

Great Asset

I would like a little more documentation in importing from a CSV file, like how working path operates, and a few "natural language" explanations on the db_table_load_csv script (specifically, what is expected from the working path and separator arguments

This review was left for a previous version of this asset.

Logo

Homunculus (Publisher) 29 April 2016

Hi! It's a good remark, CSV file import seems to be one of the most used features and it's probably not documented enough in the docs. I'll briefly explain here about work path and separator, but I'll update the docs soon.
The csv file path operates like any other path in GM. Internally it uses file_text_open_read(path), so you should consider the same constraints (sandboxing etc...). About the separator, usually it is expected of a CSV file to use comma ',' as separator, but that's not always the case, especially in localized versions of excel (mine, which is in italian, uses semicolon by default for example).


Gravatar

Anonymous 15 April 2016

Amazing!

The database is amazingly powerful! It is easily able to fulfill a variety of roles, not just your standard inventory system. The documentation is well-done, covering pretty much all you need to know. And if you still have problems, the developer is really good at explaining things and guiding you through the process.

All in all, a great buy.

This review was left for a previous version of this asset.


Gravatar

Andreas M 14 April 2016

A must have. (7 stars)

Great database functions. With this it's simple to organize inventory, shops ...
Suggestion:
Ability to have multiple databases open

This review was left for a previous version of this asset.


Gravatar

Andrea V 16 March 2016

5 stars!

Perfect database for all my game! Great!

This review was left for a previous version of this asset.


Gravatar

mostefai b 22 July 2015

very convenient

it worked perfectly for all my windows games.

This review was left for a previous version of this asset.


Gravatar

Anonymous 08 July 2015

Very Useful!

I actually used this for a simple non-game app and it worked beautifully! The developer was also very patient with my boneheaded questions. The examples and the documentation are great!

This review was left for a previous version of this asset.


Gravatar

davide m 30 March 2015

Awesome!

This asset is very well programmed and can be used in many different situations, saving you lot of time. Super happy with the documentation, too, and the publisher is very gentle and willing to help. Great!

This review was left for a previous version of this asset.

Package contents

Total size 857 KB

assetpackage.yy 25 KB datafiles datafiles_yy fonts objects
obj_db_bkg obj_db_btn obj_db_controller obj_db_intro_btn obj_db_inventory_btn obj_db_inventory_controller obj_db_items_btn obj_db_items_controller obj_db_node obj_db_nodes_controller obj_db_scores_btn obj_db_scores_controller
rooms
rm_db_intro rm_db_inventory rm_db_items rm_db_nodes rm_db_scores
scripts
csv_compose_line csv_parse_line db_autosave db_close db_cl_join db_cl_limit db_cl_only db_cl_sort db_cl_where db_exists db_export db_free db_import db_import_legacy db_init db_list_tables db_open db_op_between db_op_eq db_op_gt db_op_gte db_op_lt db_op_lte db_op_neq db_query_calc db_query_delete db_query_exec db_query_free db_query_select db_query_select_ids db_query_select_records db_query_update db_record_build db_record_create db_record_delete db_record_destroy db_record_exists db_record_fetch db_record_fetch_all db_record_first db_record_get db_record_rnd db_record_save db_record_update db_save db_table_clear db_table_column_add db_table_column_names db_table_column_remove db_table_create db_table_delete db_table_exists db_table_export db_table_export_csv db_table_import db_table_import_csv db_table_size ds_grid_multisort pair_get string_parse _db_qf_calc _db_qf_delete _db_qf_fetch _db_qf_select _db_qf_select_ids _db_qf_select_records _db_qf_sort _db_qf_update _db_query_init _db_table_column_indexes _db_table_get_path _db_table_load _db_table_merge _db_table_reindex _db_table_save _ds_grid_multisort_part
sprites

What is the issue?

Back to Top