Migrate from Smile to SQL

[Sam Taber]

Hi folks,

How would I go about migrating a relatively large Smile database to MariaDB? Want to know if this is a possibility at all. Please let me know.

Thanks,

Sam

[Tatu Saloranta]

I wonder if there is some mix-up: Smile here refers to the data format:

https://en.wikipedia.org/wiki/Smile_(data_interchange_format)

and not a database. Although obviously it is possible to store
Smile-encoded data in a database.

-+ Tatu +-

>
> --
> You received this message because you are subscribed to the Google Groups "smile-format-discussion" group.
> To unsubscribe from this group and stop receiving emails from it, send an email to smile-format-disc...@googlegroups.com.
> To view this discussion on the web visit https://groups.google.com/d/msgid/smile-format-discussion/3a074f10-f2bc-4300-8235-b75de5c37d63n%40googlegroups.com.

[holykoolala]

Can't you store smile in a smile database? [:),:)]

To view this discussion on the web visit https://groups.google.com/d/msgid/smile-format-discussion/CAGrxA25YhFpw3X8GfXfwrATL5WorA_hmNAy%2BLZjgzhSyeiSdwA%40mail.gmail.com.

[holykoolala]

It seems like the way SQLite handles JSON would work great for smile 😃 

Another place I wonder about a smile database is IndexedDB - it is also json like - and I'm really excited if we see Smile database tech on the web. I think I remember it being Java based but the new Web FileSystem stuff should work with native smile databases compiled to wasm?

[Sam Taber]

I have a client who is using it to store user data. He has hundreds of different users on his platform, and it's growing unstable. (He's implemented Smile through Java)

Apologies for the confusion.

[Tatu Saloranta]

On Tue, Jun 13, 2023 at 4:03 PM Sam Taber <samt...@gmail.com> wrote:
>
> I have a client who is using it to store user data. He has hundreds of different users on his platform, and it's growing unstable. (He's implemented Smile through Java)
>
> Apologies for the confusion.

I am sorry but that does not really answer the question at all.
Confusion continues...

The client uses what to store user data?

Do you mean that they use Smile encoding to reduce the size of JSON
content stored?
That would make sense on its own, if stored as blob value. But ref to
MariaDB is then odd.
Migrating... what?

-+ Tatu +-

> To view this discussion on the web visit https://groups.google.com/d/msgid/smile-format-discussion/13cd2b2c-dc35-4a53-a588-aaadd3bf944fn%40googlegroups.com.

[holykoolala]

My guess is the client uses Java to store it but they want to move to other more modern ecosystems?

I'm excited to see Smile databases become available. Smile is a great idea but I don't think standards are the complete picture - I do love the Wikipedia page.

I'm really interested in JSON, smile technology, and learning about the smile ecosystem today. What is happening in the world of Smile?

To view this discussion on the web visit https://groups.google.com/d/msgid/smile-format-discussion/CAGrxA25n%3DsBhYvePYBza29t7z0s1Z_DGJsuqB_VDAHmS%3DCHd7Q%40mail.gmail.com.

[Tatu Saloranta]

On Wed, Jun 14, 2023 at 9:17 AM holykoolala <holyk...@gmail.com> wrote:
>
> My guess is the client uses Java to store it but they want to move to other more modern ecosystems?

That statement makes no sense to me. Java to store... what, where?

> I'm excited to see Smile databases become available. Smile is a great idea but I don't think standards are the complete picture - I do love the Wikipedia page.
>
> I'm really interested in JSON, smile technology, and learning about the smile ecosystem today. What is happening in the world of Smile?

It is a stable binary data format, used widely.

-+ Tatu +-

> To view this discussion on the web visit https://groups.google.com/d/msgid/smile-format-discussion/CA%2Bks4WUnRh0KnidPPwB7J49E%2Bi%3Dat6k3qUfOc2_GwfKf2qffCQ%40mail.gmail.com.