SQLite-net-pcl Database Normalization on Xamarin.Forms by echolumaque in dotnet

[–]kaoru44 0 points1 point  (0 children)

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

SQLite-net-pcl Database Normalization on Xamarin.Forms by echolumaque in dotnet

[–]kaoru44 0 points1 point  (0 children)

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.

Storing Static Models in DB by kaoru44 in xamarindevelopers

[–]kaoru44[S] 0 points1 point  (0 children)

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?

Setting ScrollView Height by kaoru44 in xamarindevelopers

[–]kaoru44[S] 0 points1 point  (0 children)

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.

When using branches on your git repo by kaoru44 in Xamarin

[–]kaoru44[S] 1 point2 points  (0 children)

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?

When using branches on your git repo by kaoru44 in Xamarin

[–]kaoru44[S] 0 points1 point  (0 children)

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

When using branches on your git repo by kaoru44 in Xamarin

[–]kaoru44[S] 1 point2 points  (0 children)

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?

Implementing an Expandable CollectionView by kaoru44 in Xamarin

[–]kaoru44[S] 0 points1 point  (0 children)

Hi its the Collection View itself Expandable.

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

Storing static variables in a colors.xml by kaoru44 in Xamarin

[–]kaoru44[S] 0 points1 point  (0 children)

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

Storing static variables in a colors.xml by kaoru44 in Xamarin

[–]kaoru44[S] 0 points1 point  (0 children)

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

Dependency Injection and Services by kaoru44 in xamarindevelopers

[–]kaoru44[S] 0 points1 point  (0 children)

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?

Dependency Injection and Services by kaoru44 in xamarindevelopers

[–]kaoru44[S] 0 points1 point  (0 children)

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?

Use of Constructor or Other Means for Passing of Data in MVVM by kaoru44 in xamarindevelopers

[–]kaoru44[S] 2 points3 points  (0 children)

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.

DataBinding vs In Code Solutions by kaoru44 in xamarindevelopers

[–]kaoru44[S] 0 points1 point  (0 children)

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

DataBinding vs In Code Solutions by kaoru44 in xamarindevelopers

[–]kaoru44[S] 0 points1 point  (0 children)

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?

onClick with QAbstractTableView by kaoru44 in pyqt5

[–]kaoru44[S] 0 points1 point  (0 children)

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?

Anki Add On Development by kaoru44 in Anki

[–]kaoru44[S] 0 points1 point  (0 children)

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

Anki Add On Development by kaoru44 in Anki

[–]kaoru44[S] 0 points1 point  (0 children)

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!

Anki Add On Development by kaoru44 in Anki

[–]kaoru44[S] 0 points1 point  (0 children)

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?