gabidavila / inmemory-db Goto Github PK

PHP 100.00%

inmemory-db's Introduction

Gabi's Profile

Hi I am Gabi, I also go by Gabriela D'Ávila Ferrara, Gabriela Ferrara or Gabriela D'Ávila.

My pronoun is she/her, but I am also comfortable with they/them.

I work as a Developer Advocate for Google Cloud and have past experiences as a Data Engineer and Software Engineer. I LOVE SQL

Where I write

I usually try to write at gabi.dev or medium.com/@gabidavila. Sometimes I can get fancy and appear at the Google Cloud blog, but those no one reads ;)

I can also be found at:

Twitter: @gabidavila
Instagram: @gab1davila
LinkedIn: Gabriela Ferrara

Resources

You can find links of my talks on this Youtube Playlist: Talks and slides on SlideShare

Projects

Office Hours

I have Office Hours to talk about Google Cloud and Databases. You can find my schedule here: gabi.tips/office-hours.

Congress Who Is?

It's a Civic Tech project that needs a bit of updating, let me know if you want to help congresswhois.com.

React USA Map - a US Map without using D3

This one I REALLY NEED HELP, I don't keep up to date to React anymore, and there are tons of requests of people asking for new features and I simply don't have the bandwith to help them, please contact me if you are interested: react-usa-map

inmemory-db's People

Contributors

Watchers

inmemory-db's Issues

List Available Keys

Lists all available keys used in memory

Input:
LIST

Return

name
address
a

Flush all values

FLUSH should empty the values in memory.

Return sizes

Return the size of the stored items:

COUNT returns the number of keys used currently
DBSIZE returns the size of the current storage

INPUT	OUTPUT
`COUNT`	1000
`DBSIZE`	0.12B

Transaction Commands

BEGIN – Open a new transaction block. Transaction blocks can be nested; a BEGIN can be issued inside of an existing block.
ROLLBACK – Undo all of the commands issued in the most recent transaction block, and close the block. Print nothing if successful, or print NO TRANSACTION if no transaction is in progress.
COMMIT – Close all open transaction blocks, permanently applying the changes made in them. Print nothing if successful, or print NO TRANSACTION if no transaction is in progress.

Example:

INPUT	OUTPUT
`BEGIN`
`SET a 10`
`GET a`	10
`BEGIN`
`SET a 20`
`GET a`	20
`ROLLBACK`
`GET a`	10
`ROLLBACK`
`GET a`	NULL
`END`

INPUT	OUTPUT
`BEGIN`
`SET a 30`
`BEGIN`
`SET a 40`
`COMMIT`
`GET a`	40
`ROLLBACK`	NO TRANSACTION
`END`

INPUT	OUTPUT
`SET a 50`
`BEGIN`
`GET a`	50
`SET a 60`
`BEGIN`
`UNSET a`
`GET a`	NULL
`ROLLBACK`
`GET a`	60
`COMMIT`
`GET a`	60
`END`

INPUT	OUTPUT
`SET a 10`
`BEGIN`
`NUMEQUALTO 10`	1
`BEGIN`
`UNSET` a
`NUMEQUALTO 10`	0
`ROLLBACK`
`NUMEQUALTO 10`	1
`COMMIT`
`END`