On this page
Come into the simplistic, powerful developer cloud. Save money, increase efficiency, and optimize spend with solutions that take away the process and cut the long story short.
Ride more on open source with our commitment to open source. WebQit Cloud lets you build on open technologies that you can always bank on.
Ready for a stress-free go-live experience? Watch this space for when we come in beta.
Web-native is an approach to web tooling that seeks to solve for the traditonal, native web over vendor-specific interests. This is an especially important goal for a web community that is now fragmented into framework silos.
WebQit Community is an initiative to support an obvious community-wide paradigm shift for web-native development. We seek to drive community participation in new ideas for the web platform, and in all the projects that are revisiting much of the assumptions that brought us here, to explore new possibilities around just conventional web languages and APIs.
We're beginning this initiative by giving mentions to the actionable discussions from around the web that are painting this future of the web. It'll be nice to see the whole picture from one place.
Come into the simplistic, powerful developer cloud. Save money, increase efficiency, and optimize spend with solutions that take away the process and cut the long story short.
Ride more on open source with our commitment to open source. WebQit Cloud lets you build on open technologies that you can always bank on.
Ready for a stress-free go-live experience? Watch this space for when we come in beta.
Web-native is an approach to web tooling that seeks to solve for the traditonal, native web over vendor-specific interests. This is an especially important goal for a web community that is now fragmented into framework silos.
WebQit Community is an initiative to support an obvious community-wide paradigm shift for web-native development. We seek to drive community participation in new ideas for the web platform, and in all the projects that are revisiting much of the assumptions that brought us here, to explore new possibilities around just conventional web languages and APIs.
We're beginning this initiative by giving mentions to the actionable discussions from around the web that are painting this future of the web. It'll be nice to see the whole picture from one place.
Taste the future today from an ecosystem of open source tooling that explores the web-native approach to engineering modern web applications. It comes bringing all of the goodness of the native web platform and the traditional paradigms that have historically been traded.
We're iterating really fast - fast going from experimental to stable - on all the new possibilities we are exploring around conventional web languages and APIs, and the traditional web.
Contributions are welcome on each project! Help report typos and bugs via github issues, or submit a fix. Contributions are taken promptly and are well-acknowledged!
Taste the future today from an ecosystem of open source tooling that explores the web-native approach to engineering modern web applications. It comes bringing all of the goodness of the native web platform and the traditional paradigms that have historically been traded.
We're iterating really fast - fast going from experimental to stable - on all the new possibilities we are exploring around conventional web languages and APIs, and the traditional web.
Contributions are welcome on each project! Help report typos and bugs via github issues, or submit a fix. Contributions are taken promptly and are well-acknowledged!
Speak one familiar language everywhere, this time, with object-oriented conventions for relationships. Or query your data programmatically using a succinct API.
Visit the docs for an overview, the commands and usage guides.
Also, join the Github Discussions for OOHTML.
Help report bugs, or request features; or join in the development.
The MIT license.
Welcome to the Objective-SQL documentation. We hope you find it easy to understand and navigate.
If you have questions about anything related to the Objective-SQL, you're always welcome to ask on our GitHub Discussions.
Objective SQL can be used either from a CDN or as an npm package.
Add the following script tag to your page to include the all-in-one Objective SQL module:
<script src="https://unpkg.com/@webqit/objective-sql/dist/main.js"></script>The above tag loads Objective SQL into a global "WebQit" object.
<script>
const ObjSQL = window.WebQit.ObjectiveSQL;
</script>With npm available on your terminal, run the following command to install Observer:
$ npm i @webqit/objective-sqlImport the installed package:
// Import the initializer
import ObjSQL from '@webqit/objective-sql';Continue to learning the API.
Objective SQL is a query client that wraps powerful concepts in a simple, succint API.
Take a one-minute overview of Objective SQL.
Obtain an Objective SQL query client for your target database:
For SQL databases, import and instantiate the SQL language driver. (You'll pass in the name of an appropriate database connection driver that works for your database.)
// Import SQL
import { SQL } from '@webqit/objective-sql';
// Using the 'mysql2' connector (npm install mysql2)
const connectionDriver = 'mysql2';
const connectionParams = {
host: '127.0.0.1',
user: 'root',
password: '',
};
// Create an instance by calling .connect().
const client = SQL.connect(connectionDriver, connectionParams);
// Or by using the 'new' keyword.
const client = new SQL(connectionDriver, connectionParams);For the client-side IndexedDB database, import and instantiate the IDB language driver.
IndexedDB is a low-level API for client-side storage.
// Import IDB
import { IDB } from '@webqit/objective-sql';
// Create an instance.
const client = new IDB;To work with Objective SQL's in-memory object storage, import and instantiate the ODB language driver.
This is an environment-agnostic in-memory store.
// Import IDB
import { ODB } from '@webqit/objective-sql';
// Create an instance.
const client = new ODB;All client instances above implement the same interface:
The client.query() method lets you run any SQL query on your database.
// Run a query
client.query('SELECT fname, lname FROM users').then(result => {
console.log(result);
});Other methods give us a programmatic way to manipulate or query the database. (Docs coming soon.)
client.createDatabase() and client.createDatabaseIfNotExists() methods. (Returning a Database instance (database).)client.dropDatabase() and client.dropDatabaseIfExists() methods.client.databases() method - for listing databases, and the client.database(name) method - for obtaining a Database instance (database).database.createTable(), database.alterTable(), and database.dropTable() methods.database.tables() method - for listing tables, the database.table(name) method - for obtaining a Table instance (table).table.getAll() method - for listing entries, the table.get(id) method - for obtaining an entry, the table.count() method - for count.table.addAll() and table.add() methods.table.putAll() and table.put() methods.table.deleteAll() and table.delete() methods.Learn more about the API. (DOCS coming soon.)
Objective SQL is a superset of the same familiar, powerful SQL language you know…
SELECT post_title, users.fname AS author_name FROM posts
LEFT JOIN users ON users.id = posts.author_id;…with an object-oriented syntax for relationships, built into the language…
SELECT post_title, author_id->fname AS author_name FROM posts;…and that's SQL without the query complexity!
Learn more about the language and see just what's possible with the arrow syntax. (DOCS coming soon.)