]> git.ardis.lu - sheets-db/log
sheets-db
4 years agoUpdate frontend README for new implementation
Ardis Lu [Mon, 29 Nov 2021 03:55:09 +0000 (19:55 -0800)]
Update frontend README for new implementation

4 years agoRewrite README to reflect the new implementation
Ardis Lu [Mon, 29 Nov 2021 03:52:53 +0000 (19:52 -0800)]
Rewrite README to reflect the new implementation

The main difference being that sql.js is loaded within the Google Sheet to enable generation of an actual SQLite database binary instead of just a query.

4 years agoImplement uploading .sqlite3 to Backblaze
Ardis Lu [Mon, 29 Nov 2021 03:38:44 +0000 (19:38 -0800)]
Implement uploading .sqlite3 to Backblaze

4 years agoUpdate UI elements from SQLite to sheets-db
Ardis Lu [Sun, 28 Nov 2021 08:16:09 +0000 (00:16 -0800)]
Update UI elements from SQLite to sheets-db

4 years agoRemove favicon in demo
Ardis Lu [Sun, 28 Nov 2021 08:12:25 +0000 (00:12 -0800)]
Remove favicon in demo

This favicon is not relevant or necessary for this case.

4 years agoDelete unnecessary comments
Ardis Lu [Sun, 28 Nov 2021 07:22:53 +0000 (23:22 -0800)]
Delete unnecessary comments

cdnjs fixed the wasm MIME type issue and I'm no longer exploring Google Storage as an alternative to Backblaze

4 years agoUpdate demo to use SQLite binary instead of query
Ardis Lu [Sun, 28 Nov 2021 07:21:26 +0000 (23:21 -0800)]
Update demo to use SQLite binary instead of query

4 years agoImprove styling and UX of the sidebar
Ardis Lu [Sun, 28 Nov 2021 05:15:18 +0000 (21:15 -0800)]
Improve styling and UX of the sidebar

4 years agoUse a sidebar instead of a modal
Ardis Lu [Sun, 28 Nov 2021 04:36:51 +0000 (20:36 -0800)]
Use a sidebar instead of a modal

The sidebar persistence allows client-side caching, which improves speed for repeated loads.

4 years agoAdd emojis to menu items
Ardis Lu [Sun, 28 Nov 2021 04:29:06 +0000 (20:29 -0800)]
Add emojis to menu items

4 years agoGenerate a sqlite database instead of a query
Ardis Lu [Sun, 28 Nov 2021 04:04:37 +0000 (20:04 -0800)]
Generate a sqlite database instead of a query

Implemented by using client-side code which calls sql.js

4 years agoDelete redundant comment
Ardis Lu [Wed, 17 Nov 2021 05:07:00 +0000 (21:07 -0800)]
Delete redundant comment

5 years agoUpdate codemirror version to 5.63.1
Ardis Lu [Sun, 10 Oct 2021 21:13:12 +0000 (14:13 -0700)]
Update codemirror version to 5.63.1

5 years agoDelete unnecessary template literals
Ardis Lu [Wed, 1 Sep 2021 04:05:56 +0000 (21:05 -0700)]
Delete unnecessary template literals

5 years agoUpdate demo README
Ardis Lu [Wed, 1 Sep 2021 04:01:34 +0000 (21:01 -0700)]
Update demo README

5 years agoChange sql-wasm CDN to cdnjs
Ardis Lu [Wed, 1 Sep 2021 03:59:31 +0000 (20:59 -0700)]
Change sql-wasm CDN to cdnjs

Whatever sql.js.org is serving is currently broken, tested on multiple browsers and devices

5 years agoUpdate example SQL
Ardis Lu [Wed, 1 Sep 2021 03:50:03 +0000 (20:50 -0700)]
Update example SQL

5 years agoAdd a section on limitations
Ardis Lu [Sun, 29 Aug 2021 09:03:39 +0000 (02:03 -0700)]
Add a section on limitations

5 years agoClarify wording in README
Ardis Lu [Sun, 29 Aug 2021 09:01:44 +0000 (02:01 -0700)]
Clarify wording in README

5 years agoUpdate example SQL query to match updated database
Ardis Lu [Sun, 29 Aug 2021 09:01:13 +0000 (02:01 -0700)]
Update example SQL query to match updated database

5 years agoUpdate query MIME type to text/plain
Ardis Lu [Sun, 29 Aug 2021 07:51:38 +0000 (00:51 -0700)]
Update query MIME type to text/plain

This MIME type signals to the CDN to compress the file. The default MIME type 'application/octet-stream' will not be compressed by default.

5 years agoFetch query from CDN instead of local
Ardis Lu [Sun, 29 Aug 2021 03:16:53 +0000 (20:16 -0700)]
Fetch query from CDN instead of local

5 years agoRemove comment with hardcoded URL
Ardis Lu [Sun, 29 Aug 2021 03:09:27 +0000 (20:09 -0700)]
Remove comment with hardcoded URL

5 years agoRemove redundant .getScriptProperties calls
Ardis Lu [Fri, 27 Aug 2021 06:18:30 +0000 (23:18 -0700)]
Remove redundant .getScriptProperties calls

5 years agoReplace redundant local .getUi call with global
Ardis Lu [Fri, 27 Aug 2021 06:00:09 +0000 (23:00 -0700)]
Replace redundant local .getUi call with global

5 years agoAdd uploadToBackblaze functionality
Ardis Lu [Fri, 27 Aug 2021 05:50:04 +0000 (22:50 -0700)]
Add uploadToBackblaze functionality

5 years agoUpdate broken 'ui' references
Ardis Lu [Fri, 27 Aug 2021 05:42:02 +0000 (22:42 -0700)]
Update broken 'ui' references

5 years agoUse PropertiesService for FILE_ID master data
Ardis Lu [Fri, 27 Aug 2021 03:49:46 +0000 (20:49 -0700)]
Use PropertiesService for FILE_ID master data

5 years agoUse global constants UI and WORKBOOK
Ardis Lu [Fri, 27 Aug 2021 03:41:19 +0000 (20:41 -0700)]
Use global constants UI and WORKBOOK

Globals are more efficient than initializing them within each function

5 years agoReplace Google Sheet link with GitHub link
Ardis Lu [Mon, 23 Aug 2021 04:42:12 +0000 (21:42 -0700)]
Replace Google Sheet link with GitHub link

5 years agoAdd frontend demo
Ardis Lu [Mon, 23 Aug 2021 03:20:46 +0000 (20:20 -0700)]
Add frontend demo

5 years agoUpdate suggested file extension to .sql
Ardis Lu [Sun, 22 Aug 2021 05:28:00 +0000 (22:28 -0700)]
Update suggested file extension to .sql

5 years agoSplit logic for processing dates vs. strings
Ardis Lu [Thu, 19 Aug 2021 06:42:49 +0000 (23:42 -0700)]
Split logic for processing dates vs. strings

5 years agoInitial commit
Ardis Lu [Thu, 19 Aug 2021 05:57:58 +0000 (22:57 -0700)]
Initial commit

This page took 0.071907 seconds and 4 git commands to generate.