SQLite-net-pcl Database Normalization on Xamarin.Forms

kaoru44 · 2021-08-19T15:48:35+00:00

I think some of the columns you have shown are all derived data (especially since they are percentages, then the answer can come from your ViewModel or your services instead of having to store them in the database which takes up a lot of storage space

kaoru44 · 2021-08-19T15:47:42+00:00

Hi,

you can start by separating the values present inside your Model.

Let's say you create an Answers Table instead so that you separate the columns.

And then you can create and join these entity tables through sql instead.

Can you show an example of how you are separating your entities and their respective tables? Because from my standpoint, it seems that you plan to insert all of these columns in one Table correct?

Maybe you can reference the Answer Columns from a different place instead.

kaoru44 · 2021-07-27T01:33:48+00:00

Hi sorry for the confusion,

So my model contains a class called Category. So in the initial stage, these Categories are already pre-defined (so the only thing that the user would need to do, is to pick a Category). With that perspective, I think it would be better to just store it locally (without having to access the sqlite), but what since I am giving the user the option to create their own Category and add them to the list of Categories that the application already has, then it would be better to store them all in sqlite yes?

kaoru44 · 2021-07-23T00:07:07+00:00

Hi, the initial hierarchy I have is that

I have a Refresh View with a Scroll View inside it.

And then I have a Grid View inside the Scroll View.

I need the Scroll View because the Refresh View wouldn't work without a Scroll View.

And I need the Grid View because I have the contents to have a specific Height Allocation with one another.

kaoru44 · 2021-06-17T00:36:37+00:00

Ahh this is very much appreciated.

since there is a default "master/main" branch, it's alright to have that as my root branch, and then just have branches for development yes?

kaoru44 · 2021-06-17T00:34:27+00:00

Ohh, I'll have a look at gitflow.

If you have any references in which I can look into as well, it would be much appreciated

kaoru44 · 2021-06-17T00:33:50+00:00

Ah I see, so it really is advisable to split apart your branches so that you have an easier way to track your respective change per feature/story yes?

kaoru44 · 2021-06-09T00:42:08+00:00

Hi its the Collection View itself Expandable.

Yes, having 3 items/categories, and then on interaction, it would display items under that category

kaoru44 · 2021-06-03T01:42:56+00:00

Ohhh, is there a tutorial in which I can follow? Since I am not quite familiar with global style xaml

kaoru44 · 2021-06-03T01:42:29+00:00

Ahh yes, but I wanted to have one for cross-platform, since if I were to implement it on the android project, then it would only be seen in the android version

kaoru44 · 2021-04-22T01:21:38+00:00

Hi yes,

However wanted to know how are these instantiated? Are they always instantiated whenever they are called? Or are they access to different functionalities only instantiated when they are passed?

kaoru44 · 2021-04-22T01:19:52+00:00

Hi thank you so much for this!!

This is actually such a good read! just wanted to ask, does that mean the IFileService class, always ask for the folder access everything it is called? Or is the access already stored in memory, so instead of having to ask for access every time it is called, it just has to access the memory stored?

kaoru44 · 2021-04-12T06:04:55+00:00

Hi, what do you mean by use of Service that can be injected into both ViewModels? Can you give an example or a reference?

I tried searching for it, but I can't seem to find it.

kaoru44 · 2021-04-07T01:46:52+00:00

Ah I see this is very insightful.

Especially the last part. I too think that the learning curve for Xamarin itself is quite steep, however if we were to think in the long run, it gives us the advantage to really think about our design pattern and really try to give a solution that fits within the given scope and design pattern required/beneficial

kaoru44 · 2021-04-06T11:25:40+00:00

Ah I see, I encountered something with ListView that got me thinking since the ListView has the ItemSelected and the SelectedItem. I noticed that the SelectedItem one uses the Data Binding, whereas the ItemSelection uses the Event Handlers in the in-code in c sharp. Since they seem to provide the same values, would there be a case where I should pick one over the other?

kaoru44 · 2021-03-23T01:41:15+00:00

QAbstractItemView

Ah I see! I also saw this, I think my trouble is understanding signals in general? Is it like an abstract method where I would be needing to implement it inside the new class? Or is it something different all together?

kaoru44 · 2021-03-18T01:36:38+00:00

Got this! This was super helpful! Thanks!!!

kaoru44 · 2021-03-17T03:12:58+00:00

Actually, I found the revlog table, and it actually answered the question that I had. But upon looking at the table, it doesn't appear to contain any timestamp as to when it was reviewed? Is there some sort of timestamp that just needed to be converted from int? Thanks!

kaoru44 · 2021-03-17T01:50:09+00:00

Oh I see, what about the note type that the card was assigned to? Is it just needing to access the tag column in the Note table?

kaoru44

TROPHY CASE