const XLSX = require('xlsx');

const wb = XLSX.utils.book_new();

const ws = XLSX.utils.json_to_sheet([]);

XLSX.utils.book_append_sheet(wb, ws, 'Bug sheet');

ws.A1 = { t: 's', f: 'square' };

XLSX.writeFile(wb, 'formula.ods');

The resulting .ODS file contains:

<table:table-cell table:formula="of:=square" office:value-type="string"><text:p>undefined</text:p></table

Your documentation shows no way to replace an objects value. Any updates to an object with:

db.get(name).find(selectors).assign(data).write()

merges the data with the existing object...not what I'd expect.

How can we replace a record without merging? Can you update your docs?

Issue

Per MongoDB specification, to query if the array field contains at least one element with the specified value, use the filter { <field>: <value> } where <value> is the element value and <field> the a field in the document that contains an array as value.

Info

• Environment: browser

I'm looking at the react tutorial at https://github.com/amark/gun/wiki/React-Tutorial and noticed that the code examples are using depreciated lifecycle methods such as componentWillMount.

Documentation Feedback

How can I test the messaging().onMessage method?

I tried to issue the SharedEventEmitter.emit ('messaging_message_received') event but was unsuccessful.

Any workaround?

The on-line demo at http://kripken.github.io/sql.js/examples/GUI/ does not give error messages (for wrong SQL or missing tables or attributes).
The version of @lovasoa does: http://lovasoa.github.io/sql.js/GUI/

This is to fix: Nozbe/WatermelonDB#186

Right now, deleting records is not very efficient in WatermelonDB.

Say you have models like this: Blog has_many Post has_many Comment. If you want to delete a blog post, you also have to delete all its posts, and all their comments. This happens one-by-one currently. What we need is the ability to efficiently (and atomically if

In the tutorial events there is this example:

const User = bookshelf.model('User', {
  tableName: 'users',

  initialize() {
    this.on('saving', (model) => {
      return User.forge({email: model.get('email')}).fetch().then((user) => {
        if (user) 
            throw new Error('That email address already exists')
    

Need help providing more samples and better flow documentation of the DBCore interface and all its methods and related interfaces. For a skilled developer, it is possible to lab with DBCore even based on the minimal docs we have now, by looking at existing middlewares and create a custom middleware.

There is a skelleton of docs around the DBCore interface right now that is not very easy to foll

There's been a number of questions lately about data not appearing in the store when you expect, so I thought it would be a good time to take a second to explain the process of opening a database and getting data out of it. The database can be either local or remote.

Important Note: While content discovery can happen via the IPFS distributed hash table, due to the limitations of browser-bas

Great app, thanks it.

Kind of related to #110. Can you update the docs that it's able to used via docker pull? Because it's really hard to find out, that actually it has an image on docker hub.

json type on mysql not support pretty format?

SQL queries sometimes are slow... for example if you don't use indexes. Showing query time in seconds is a nice to have feature.

The explain analyze button doesn't use buffers. Offering explain (analyze, buffers) sounds like very helpful feature to me. I even think that explain (analyze, buffers) might be the better default for analyzing queries. That differs from verbose, which is not considered as very helpful by a major part of the community.

All the best
pgaro

Shouldn't PUT requests be for updating key/value pairs within a document, and POST for overwriting/creating a document? PUT behaves the same as POST in this instance.

I am trying to generate a TypeScript model, and I am getting the above error.

My model looks like this:

/* jshint indent: 2 */
// tslint:disable
import * as sequelize from 'sequelize';
import {DataTypes} from 'sequelize';
import {email_tblInstance, email_tblAttribute} from './db';
module.exports = function(sequelize: sequelize.Sequelize, DataTypes: DataTypes) {
  return sequelize.

• Include a link to the documentation section or the example
  Couldn’t find one...

• Describe the confusion
  I just want to make Graph queries from a serverless function in Nodejs to an oracle cloud database

• Suggest changes that would help
  Please add an example of connecting a nodejs server to oracle cloud database and then basic CRUD with PGQL

In case you find it useful, we're using this extension. Just not to forget $set!

DBCollection.prototype.set = function(query, setUpdates) {
    return this.update(query, {$set:setUpdates}, false, true);
};

Hi, First and foremost, I think this is a great start at making something really simple and effective. Thank you!!

However... I have always found template strings a little odd especially in this context.
Let us say we have

const query = `SELECT ${distinct}, ${columns} FROM ${table} ${innerJoins} WHERE ${where}`;
(Where distinct, columns, table etc are their own strings made up of other

On every delete operation on items from the to-do example the password manager is triggered (tested 1password on mac on my laptop). A prompt is shown to store the password.