Local SQL files for mobile clients
In one embodiment, a method includes receiving a request from a mobile client system for an event attendee list and transmitting a request to a data store for the event attendee list. If the event attendee list is available on the data store, then receiving the event attendee list from the data store, else transmitting a request to a data store for the event attendee list and receiving the event attendee list from a module. After receiving the event attendee list, the method includes transmitting the event attendee list to the mobile client system.
1. A method implemented by one or more processors of one or more servers associated with an event management system that includes a local file store and a relational database, comprising:
receiving, by one or more of the servers, a request for an event attendee list from a first mobile check-in device, the first mobile check-in device being associated with an event organizer of the event and with a check-in location at a venue for an event, wherein the first mobile check-in device comprises a embedded-database engine, wherein the event attendee list is a complete structured query language client-side database comprising a plurality of tables, indices, and triggers, and wherein the event attendee list identifies, for each of a plurality of attendees of the event:
a ticket identifier associated with a ticket for the event, the ticket being associated with the attendee;
an attendee identifier associated with the attendee; and
whether the attendee is checked-in or not checked-in;
retrieving, by one or more of the servers, the event attendee list, wherein:
if the event attendee list is available in the local file store of the event management system, then retrieving the event attendee list from the local file store;
else:
retrieving attendee data associated with the event from the relational database;
converting the attendee data into the event attendee list; and
storing the event attendee list in the local file store of the event management system; and
transmitting, by one or more of the servers, the event attendee list to the first mobile check-in device.
2. The method of claim 1 , further comprising:
periodically receiving from the first mobile check-in device a first event attendee list update identifying the one or more attendees checked-in with the first mobile check-in device; and
periodically transmitting to the first mobile check-in device a second event attendee list update that identifies one or more attendees who have checked-in with one or more second mobile check-in devices.
3. The method of claim 2 , wherein:
the first event attendee list update is an application programming interface call and the second event attendee list update is a structured document object notation string.
4. The method of claim 1 , wherein:
the event attendee list that is a client-side database comprises one or more order identifiers;
each order identifier is associated with one or more attendee identifiers; and
each attendee identifier is associated with one or more ticket identifiers.
5. The method of claim 1 , wherein the request is hypertext-transfer protocol request message using an application programming interface.
6. An apparatus comprising: one or more processors; and a memory coupled to the processors comprising instructions executable by the processors, the processors operable when executing the instructions to:
receive a request for an event attendee list from a first mobile check-in device, the first mobile check-in device being associated with an event organizer of the event and with a check-in location at a venue for an event, wherein the first mobile check-in device comprises a embedded-database engine, wherein the event attendee list is a complete structured query language client-side database comprising a plurality of tables, indices, and triggers, and wherein the event attendee list identifies, for each of a plurality of attendees of the event:
a ticket identifier associated with a ticket for the event, the ticket being associated with the attendee;
an attendee identifier associated with the attendee; and
whether the attendee is checked-in or not checked-in;
retrieve the event attendee list, wherein:
if the event attendee list is available in a local file store of an event management system, then retrieving the event attendee list from the local file store;
else:
retrieving attendee data associated with the event from a relational database;
converting the attendee data into the event attendee list; and
storing the event attendee list in the local file store of the event management system; and
transmit the event attendee list to the first mobile check-in device.
7. The apparatus of claim 6 , wherein the processors are further operable when executing the instructions to:
periodically receive from the first mobile check-in device a first event attendee list update identifying the one or more attendees checked-in with the first mobile check-in device; and
periodically transmit to the first mobile check-in device a second event attendee list update that identifies one or more attendees who have checked-in with one or more second mobile check-in devices.
8. The apparatus of claim 7 , wherein:
the first event attendee list update is an application programming interface call and the second event attendee list update is a structured document object notation string.
9. The apparatus of claim 6 , wherein:
the event attendee list that is a client-side database comprises one or more order identifiers;
each order identifier is associated with one or more attendee identifiers; and
each attendee identifier is associated with one or more ticket identifiers.
10. The apparatus of claim 6 , wherein the request is hypertext-transfer protocol request message using an application programming interface.
11. One or more computer-readable non-transitory storage media embodying instructions that are operable when executed to:
receive a request for an event attendee list from a first mobile check-in device, the first mobile check-in device being associated with an event organizer of the event and with a check-in location at a venue for an event, wherein the first mobile check-in device comprises a embedded-database engine, wherein the event attendee list is a complete structured query language client-side database comprising a plurality of tables, indices, and triggers, and wherein the event attendee list identifies, for each of a plurality of attendees of the event:
a ticket identifier associated with a ticket for the event, the ticket being associated with the attendee;
an attendee identifier associated with the attendee; and
whether the attendee is checked-in or not checked-in;
retrieve the event attendee list, wherein:
if the event attendee list is available in a local file store of an event management system, then retrieving the event attendee list from the local file store;
else:
retrieving attendee data associated with the event from a relational database;
converting the attendee data into the event attendee list; and
storing the event attendee list in the local file store of the event management system; and
transmit the event attendee list to the first mobile check-in device.
12. The media of claim 11 , wherein the media further embodies instructions that are operable when executed to:
periodically receive from the first mobile check-in device a first event attendee list update identifying the one or more attendees checked-in with the first mobile check-in device; and
periodically transmit to the first mobile check-in device a second event attendee list update that identifies one or more attendees who have checked-in with one or more second mobile check-in devices.
13. The media of claim 12 , wherein:
the first event attendee list update is an application programming interface call and the second event attendee list update is a structured document object notation string.
14. The media of claim 11 , wherein:
the event attendee list that is a client-side database comprises one or more order identifiers;
each order identifier is associated with one or more attendee identifiers; and
each attendee identifier is associated with one or more ticket identifiers.
15. The media of claim 11 , wherein the request is hypertext-transfer protocol request message using an application programming interface.