OWN JSON QUERY DATABASE: BRIDGING NoSQL and SQL

Abstract: A traditional SQL plus NoSQL database has its major point of expansion as well as limitation in correlation to local storage situations for fast scalability. The paper presents the JSON Query Database (JQDB) as a lightweight local database application written in Python, which promises ease of such NoSQL-like flexibility but structured querying akin to SQL. This combination allows users to operate JQDB under SQL or NoSQL mode, specifying the mode at the database initialization, while CRUD is driven through a custom query language. JQDB operates entirely off local storage, hence not requiring any network database setup. JQDB is built with Python, employs JSON for data storage, has a basic command-line interface, and offers front-end integration for easy interactions. This paper discusses the architecture behind JQDB, command execution, and future work, thus establishing the capability of lightweight yet powerful local database solutions

Keywords: NoSQL Database, SQL-like Commands, Local Storage, Python Database, CRUD Operations.