cherry3

Cherry3 is a SQlite And PostgreSQL object modeling tool designed to work in an asynchronous environment.

Installation

Using npm:

$ npm install cherry3

$ npm install sqlite3 -g   # ( For SQlite )
$ npm install pg -g   # ( For PostgreSQL )

Other Installations:

$ yarn add cherry3

$ pnpm add cherry3

Features

• Simple Setup: Get started quickly with minimal configuration.
• SQlite And PostgreSQL Storage: Sqlite And PostgreSQL Will Come To Your Help Because It Is Compressed, Economical And Fast.
• Asynchronous Operations: Perform Database Operations Asynchronously Using Promises.
• Filter and Update: Easily filter and update records in your collections.

Documentation

=> Click Here

Usage

import { Model, Schema, Types } from 'cherry3';
/* const { Model, Schema, Types } = require('cherry3'); For CommonJS */

// Define a schema for a collection
const userSchema = Schema({
    username: { type: Types.String, default: 'fivesobes' },
    age: Types.Number,
    email: { type: Types.String, default: "[e-mail]" },
    isAdmin: Types.Boolean,
    interests: Types.Array,
    balance: Types.Float,
    date: Types.Date
});

// Create a model for the "users" collection
const UserModel = new Model('Users', userSchema);


// Example data
const userData = {
  username: 'fivesobes',
  age: 20,
  email: '[e-mail]',
  isAdmin: false,
  interests: ['coding', 'reading', 'ertus-mom'],
};

(async () => {
// CRUD operations
  try {
    /* FIND USERS */

    // Find multiple users with conditions
    const users = await UserModel.find({ age: 20, isAdmin: false });
    console.log(users);


  } catch (error) {
    console.error('Error performing CRUD operations:', error.message);
  }
})();

Settings File Definitions

=> Click Here

Types

import { Types } from 'cherry3';

Types.Number // Example => 5
Types.Object // Example => { test:"data text", test3: 5 } 
Types.Date // Example => 1.03.2024
Types.String // Example => "test data text"
Types.Boolean // Example => true or false
Types.Array // Example => [ "five" , "so" , 5 ]

Sqlite Viewer Extension

For Visual Studio Code

PostgreSQL And Other Database Viewer Extension

For Visual Studio Code

License

Cherry3 is licensed under the GPL 3.0 License. See the LICENSE file for details.

Changelog

=> Click Here

Support

Changelog

Version 5.2.0

• Fixed TypeScript Typing, Synchronized updateOne, UpdateMany, find and allRows $sort Type and Schema Parameters.
• The errors in the Update Operators $set and $unset have been corrected, the Object Structure now works smoothly.