My current application makes use of SQLite for storage, but I am looking to switch it up to make it compatible with Firefox and other browsers.
I've been considering localStorage as an option. However, I've noticed that localStorage lacks some of the more advanced SQL functionalities such as OrderBy, GroupBy, and table joins.
Does anyone know of a JavaScript library that can be used with localStorage to provide more SQL-like functionality? - Appreciate any advice!
For easy interfacing with localstorage, consider using one of the JavaScript LINQ implementations. These implementations retrieve data from plain JavaScript objects/arrays, simplifying the process.
or check out
You can explore an online demo of these tools here: (note the available options on the top left)
While I'm not entirely certain about the insert/update functionality, these tools are great for performing data querying tasks.
If you're looking for a solution, consider checking out sql.js. It's an impressive conversion of SQLite from its native C form to pure javascript.
Consider trying out alasql.js, a SQL database implemented in pure JavaScript. While it may not have built-in support for working with localStorage, you can easily manage data storage and retrieval before and after sessions or updates.
Below is a sample showcasing how Alasql can be used in conjunction with localStorage:
// Setting up the database and table structure
var db = new alasql.Database();
db.exec('CREATE TABLE students (studentid INT, school STRING)');
// Retrieving table data from localStorage if available; otherwise, creating a new table
if(localStorage['students']) {
db.tables.students.data = JSON.parse(localStorage['students']);
} else {
db.tables.students.data = [
{studentid: 55, school: 'abc'},
{studentid: 56, school: 'klm'},
{studentid: 57, school: 'nyz'}
];
localStorage['students'] = JSON.stringify(db.tables.students.data);
};
// Adding a new student record and saving the database
db.tables.students.data.push({student: 100, school:'qwe'});
localStorage['students'] = JSON.stringify(db.tables.students.data);
// Executing an SQL-query
console.log(db.exec("SELECT * FROM students WHERE school > 'ght'"));
You can also view this example on JSFiddle.
If you're in search of a HTML5 / JavaScript Relational Database option as an alternative to SQLLite, look no further than SequelSphere
SequelSphere is a versatile Javascript library compatible with modern browsers and platforms, utilizing IndexedDB and LocalStorage for data storage based on browser support. It seamlessly integrates with various 3rd party RIA frameworks and includes "change trackers" for efficient data synchronization.
In response to your inquiry regarding complex SELECT capabilities, check out some highlights from SequelSphere's site at: Top 9 Cool SequelSphere Features
An outstanding feature of SequelSphere is its groundbreaking SQL parsing and execution engine. Beyond standard SELECT features and expressions, it excels in handling LEFT, RIGHT, and FULL outer joins. Not only does it manage unlimited nesting of Sub-queries, but also in major clauses like SELECT, FROM, WHERE, JOIN, ON, HAVING, and GROUP BY. Additionally, it supports grouping sets, rollup, cube, and grand-total grouping functions. It proficiently handles complex conditional expressions such as:
(a,b) not in ((1, 2), (3, 4), (select c, d from tab))
Furthermore, the ability to incorporate custom, user-defined functions and third-party tables dynamically adds to its exceptional SQL engine capabilities. Unlike any other, this SQL engine operates entirely in JavaScript across all major browsers and platforms, ensuring rapid speed in parsing, planning, and optimization within sub-milliseconds.
Just for transparency: I'm involved with SequelSphere, and I must say, the product is truly remarkable.
Experience the convenience of my innovative open source toolkit https://bitbucket.org/ytkyaw/ydn-db/wiki/Home which offers support for IndexedDB, WebSQL, and web storage with a plethora of advanced query features. Discover how effortlessly you can leverage this powerful tool!
I am currently facing a challenge where I must retrieve the value of an input field in order to initiate an API request. Here is my current setup: import React, { Component } from 'react' import axios from 'axios'; const fetchWeather ...
For more information, you can visit the original post here. The task at hand seems to be quite complex due to the lack of documentation and examples on this specific topic on the three.js website. Currently, I am able to render the correct image and, with ...
Seeking assistance and insight for a coding dilemma I'm facing. In my Rails application, I have a controller named get_songs that retrieves a hash of songs belonging to the currently logged-in user. What I'm trying to achieve is to fetch this dat ...
JSBin link: http://jsbin.com/4QLDC/6 Here is the JS code snippet that I have written: var toggleContent = function (event) { $(event.target).siblings().toggle(); }; var showOrHidePanels = function () { var windowHeight = $(window).height(); v ...
.dd{ height:100px; width:100%; border:1px soild red; background:#000; } .dd .d1{ height:20px; width:20px; border:1px solid green; display:inline-block; } .dd .d2{ height:20px; width:20px; border:1px solid green; display:inl ...
Hello everyone, I'm hoping things are going well. I am currently working on removing newline and "\" characters from a string that I have after using JSON.stringify(). The string in question appears as follows: "[{\n \"id_profile&bs ...
I am currently working on a code to delete an item from a list. However, I have encountered a problem where it is deleting items in a FIFO order instead of according to the index. export default class Todo extends Component{ constructor(){ supe ...
My task is to develop a web application using HTML, CSS, and JS with the following functionality: Retrieve a list of users from this API: https://jsonplaceholder.typicode.com/users. Upon clicking on a user, show a list of albums associated with that user ...
{ "name": "unique-react", "version": "2.0.1", "private": true, "scripts": { "start": "webpack-dev-server --hot --port 3002 --open --inline", "build": "cross-env NODE_ENV=production rimraf dist && webpack", "package": "webpack -p ...
Recently, I attempted to implement Dynamic routing for a recipe app but encountered an issue where the page was not found. This problem has left me puzzled as I am fairly inexperienced with TypeScript, although not with React. // pages/recipes/[recipeId].t ...
Who just handed out an L to user#0000? Looks like JohnGameRage#0000 did! ...
Okay, I believe it would be more helpful if I provide my entire node.js route for you to better understand what I am trying to explain. The issue I am facing is with making multiple queries to my MongoDB database (one for each day). The queries are execut ...
In my current project, I have implemented a component that wraps multiple ReactList components. The ReactList component features infinite scrolling, meaning it only loads what is currently in the viewport. There are two modes available - simple and uniform ...
This might not be the most popular question, but I'm asking for educational purposes... Here is my current setup: data = {COLUMN1: "DATA1", COLUMN2: "DATA2", COLUMN3: "DATA3", ..., COLUMNn: "DATAn"}; keyColumns = ["COLUMN2", "COLUMN5", "COLUMN9"]; ...
After receiving the input from req.body, it looks like this: [ { "Name": "Test_1", "Level 1": "Story_1", "Level 2": "Story_1.1" }, { "Name": & ...
I have been working on a project using React and Bootstrap. I decided to switch to material-ui, which went smoothly except for the radio buttons. Below is the original code that worked well: <label> <input type={that.props.questionType} name ...
I tried the solution provided in this discussion thread (Saving without dialog window) to save an image as PNG without triggering the 'Save as..' dialog. It worked perfectly on my Windows computer. However, when I shared the script with my collea ...
When I create a window using window.open in my NWJS application, it appears that the window is unable to access any nodejs or nwjs modules. How can I find a solution for this issue? I utilize document.write to add content to the page because the content m ...
When utilizing jQuery's .html() property to populate a select box, I encountered an issue where the spaces between words were being trimmed down to just one space. Despite including multiple spaces in the option, it would always resolve to a single sp ...
Currently, I am facing a challenge in passing an event downward with a bound change listener to a child input component. Although I am utilizing wrapped input components, my goal is to define methods within the parent component. //App.js: <currency-inp ...