mayvelous

Me, Myself and Mayvelous

Archive for the ‘Tools’ Category

CrazyEgg Visitor Stats Tracking

crazyegg stats tracking serviceCrazy Egg is yet another web statistic tracking service. It displays in 3 formats:

  • Overlay – % clicks, referal links
  • List – view a full summary of raw clicks
  • Heat Map – shows the most click areas on the page.

There are 3 paid plans and a free plan. A free account is ideal for a small personal site such as blog to track the visitor stats. Ofcos, there is a limit of 5,000 visit/month, 4 pages and 4 screenshots archive for the free plan. Very neat interfaces so you can consider using it for your blog stats tracking.

  • Comments Off
  • Filed under: Aside Notes, Blogging, General, News, Site Reviews, Technology, Tools, Web
  • Source Control Resources

    Here are some of the readings on Subversion and VSS that I came across. Whoever interested in Source Control and its available tools should go through these links first to get to know the technologies out there. I’m just concentrating on SVN and VSS, but there are a lot more to look at. Depending on your choice of technology, google would be your best reference.

    Documentations:

    Good Reference Articles

    No to Visual SourceSafe? Bad Toad! Bad Toad!

    I’ll be adding more later and if you find some good readings/articles, do let me know too.

    TortoiseSVNOie Turtle turtle, little tortoise, kuchi kuchi kooo…
    Oh hello, I’ve just adopted a Tortoise recently. You see, we use to play with this creature called VSS before, but it got wild from time to time and the guys don’t like it much. I don’t like it in the beginning too. I did strangled and fist-fight with it for many times. But the thing is, you only need a bit of patience and time to tame him down. Once I start petting and playing with it, I tend to understand it’s tender part as well as bewilder sides. As you all know, everything has its own pros and cons; our VSS rode a bumpy road and came as an arse but it has soothen out after a while. At least for me, I’m on fair term with him.

    TortoiseSVN

    Now I found a new pet. It’s really a sweet and gentle thing to start with. It says “Hello” and wags a little tail. Oh just so cute!

    SubversionBefore you start with the tortoise, you have to know its family tree; the big fat “Turtles” – Subversion (SVN) evolved from their ancestors called CVS back in ice-age. I’m not interested in CVS but I’m very much interested in SVN and how the little TortoiseSVN communicates to its parents.

    So I did a bit of research on Googology and started learning about the whole Tortoise family and their neighborhood. So here we go…

    What is SVN?

    Subversion is an open source application for revision control, is a replacement for CVS. The goal of the subversion project is to build a version control system that is a compelling replacement for CVS in the open source community.

    Subversion’s Features (# Parent Site) (# Wiki)

    What operating systems does Subversion run on? (# Portability)

    All modern flavors of Unix, Win32, BeOS, OS/2, MacOS X.

    Subversion is written in ANSI C and uses APR, the Apache Portable Runtime library, as a portability layer. The Subversion client will run anywhere APR runs, which is most places. The Subversion server (i.e., the repository side) is the same, except that it will not host a Berkeley DB repository on Win9x platforms (Win95/Win98/WinME), because Berkeley DB has shared-memory segment problems on Win9x. FSFS repositories (introduced in version 1.1) do not have this restriction; however, due to a limitation in Win9x’s file-locking support, they also don’t work in Win9x.

    To reiterate, the Subversion client can be run on any platform where APR runs. The Subversion server can also be run on any platform where APR runs, but cannot host a repository on Win95/Win98/WinMe.

    It’s not necessary to set up Apache to use Subversion on the client sides.If you just want to access a repository then can use subversion client such as TortoiseSVN to integrate with the server. Only when you want to host a networked repository then you have to set up on Apache2 or an “svnserver” server. More info see FAQs (#)

    What is TortoiseSVN?

    It’s a free open-source client for the Subversion version control system, implemented as Windows shell extension. TortoiseSVN manages files and directories over time. Files are stored in a central repository. Its immediate ancestor was TortoiseCVS which talks to CVS server. (# Doc)

    TortoiseSVN’s Features (# Doc)

    • Shell integration
    • Icon overlays
    • Easy access to Subversion commands
    • Directory versioning
    • Atomic commits
    • Versioned metadata
    • Choice of network layers
    • Consistent data handling
    • Efficient branching and tagging
    • Hackability

    You can also integrade with Visual Studio.net using this tool called AnkhSVN. It is a Visual Studio .NET addin for the Subversion version control system. It allows you to perform the most common version control operations directly from inside the VS.NET IDE. Not all the functionality provided by SVN is (yet) supported, but the majority of operations that support the daily workflow are implemented. (#)

    I think this is all for today’s learning about my new pet. I’ll add more detail on how to feed things and teach your pet A,B,C,D later.

    So you want to adopt a Tortoise too? Here are where you can get it from and how to look after it.

    # Get Subversion here
    # Get TortoiseSVN here.
    # Download AnkhSVN

    LLBLGen vs CodeSmith

    Comparison between LLBLGen Pro and CodeSmith tools. I’m very new to both so the following points might be completely wrong. So correct me please and do fill in more.

    LLBLGen CodeSmith
    O/R Mapper + Code Generator Template based Code Generator
    Uses Parameterized Dynamic Queries Mainly Stored procedures
    Cost license fee,
    Need to buy template studio for custom template creation/management.
    Free (console version)
    Comes as templates so add/update or manage as you wish.
    On-fly code generation, you don’t get to see templates or whatsoever. Gives control over the whole process, top-bottom, as they are managed by individual templates
    Does not create DB schema/generation. Creates the whole DB structure ie. Storeprocs, triggers, tables, functions etc
    N-tier generated with one go ie. If you change something in DB, you just regenerate the llblgen project and all files get updated. Individual template/batch file generation ie. You need to run B&D batch, channel batch etc one by one to get update files across 3 layer solutions.
    No webservices, remoting or channel server. Just uses classes and collections – entities, typelist, typeviews etc Can add as much layer separation between DB end and UI end. Can manage as you wish just by working on templates
    Less code – 2 projects, 1 solution More code, some redundant – multiple projects, 3 solutions
    N-tier project structure
    - Database Generic
    - Database Specific
    - UI
    (2 types: Adapter based or SelfServicing)
    N-tier project structure
    - Business and Data
    - Public Channels
    - Presentations
    (Add more as you wish)
    Do sorting, filtering, grouping, paging, all DB queries by a few class calls. (Dynamic queries) Need individual storeproc for each function. Adding one function needs to do individual updates for all projects and across solutions as well. Extensive use of storeproc.
    It is n-tier but basic multi tier structure which separate Business data code from UI codes. Advance/better n-tier architecture. Greater security and more control over each layers.
    Easier code generation + usage + less error generation. Need proper setup or you’ll get tangle in between. Small error in your base template will affect the entire project code.
    You write very little code ie. Only need to write for UI code. You have to write all the codes for your based templates if you don’t already have templates in hand.
    Provide .net 1.1, and .net 2.0 classes, ready to use and choose whichever you need. No .net 2.0 codesmith templates for us yet. Can use third-party templates but it will cost us.
    It doesn’t require dotnet framework and work independently. Uses dotnet framework as main backbone.

    # References:

    # Debate: O/R Mapping or Code Generation : Lots of discussion going on there in the reply threads.
    # Your Favorite O/R Mapper? : A discussion on O/R Mappers
    # CodeSmith Rocks! | When code generation goes bad…
    # LLBLGenPro vs CodeSmith w/ .netTiers

    What is O/R Mapper?

    O/R Mapper (Object-Relational Mappers) is a programming technique for converting data between incompatible type systems in databases and Object Oriented Programming languages. (# Ref)

    What does it do?

    The generated code from the O/R Mapper handles all of the steps that you would normally have to code yourself, saving you from having to:

    • Find the database server.
    • Log in and open a connection to the database server.
    • Select the particular database containing the information you want.
    • Find the correct table.
    • Find the correct row.
    • Read all the values for that row.
    • Convert every type of value from its SQL data type into the .NET data type while checking and handling the possibility of a null value.
    • Present those values in a strongly-typed format, so the consumer knows exactly what kind of object to expect (string, integer, array, etc.) and there are no surprises at run-time.
    • Create a container to temporarily hold the values while they are being modified.
    • Retrieve data from another row in a related table.
    • Manage which values have changed and make appropriate INSERT’s, UPDATE’s, and DELETE’s in the appropriate tables in the database to reflect those changes.
    • Close the connection.

    What is LLBLGen Pro

    LLBLGen Pro is a complete O/R mapper and data-access tier generator for .NET. It generates a data-access tier and business façade/support tier (in C# or VB.NET), using an existing database schema set. The generated .NET code is provided as a Visual Studio.NET project that can be added to a solution or compiled separately. (# Ref + More Info)

    LLBLGen Pro Features

    Rapid C# Windows DevelopmentA key feature in LLBLGen Pro is dynamically-generated SQL. When retrieving or manipulating data in a database, the SQL script — the code understood by the database — is generated at run-time based off the requested information and dirty flags in each entity’s fields. This enables a generic save entity function on the Data Access Tier to produce different and optimized SQL code each time it is called, optimizing bandwidth usage and database load. (# Ref)

    • LLBLGen Pro will completely auto-generate the data access layer. You do not need to do any hand-coding in this layer
    • LLBLGen Pro will optionally generate a business logic layer shell for you to get started with your business layer. You do not have to understand the intricacies of inheritance and making custom classes to take advantage of business logic classes; in LLBLGen Pro these classes are intuitively organized, powerful, and infinitely extendable.
    • LLBLGen Pro collections and entity objects are bindable, making them extremely easy to add to .NET controls. This can reduce the size of your UI layer.
    • Changing the database application and the data access layer without affecting the business logiv and UI layers is actually possible with LLBLGen Pro. If you migrated your database schema and stored procedures to a new database application, refraned from using any database-specific features and your schema matched exactly, you could actually re-generate your LLBLGen Pro data access layer and not make any other changes to your application.

    # Ref: Rapic CSharp Windows Development. pp. 17

    LLBLGen Pro Objects

    • Entities: Every “Row” becomes an “Entity”
    • Collections: Every “Table” becomes an “EntityCollection”. Collection classes eliminate the need for DataTable objects and are both strongly typed and bindable.
    • Entity relationships: Build into each entity are all relationships in the DB involving that table. You can either get a single entity or an entity collection depending on the type of relationship.
    • Typed views: Views in the DB can be wrapped as strongly-typed DataTable. Typed views are read-only; new LLBLGen Pro allows you to add a view from the database as an entity as well as a typed view.
    • Typed Lists: Typed lists are the only objects created by LLBLGen Pro that do not correspond one-to-one with DB objects. It’s handy when you need very specific information that does not necessarily correspond to a single table or entity or you only want to grab a subset of information for a given set of table.
    • Storedprocedures caller classes: Storedproc that you select will be wrapped in a layer of code. While the parameters of the stored procedures are strongly-typed, the result set is still an untyped DataSet.

    Project Types: SelfServicing Vs. Adapter

    There are two types of LLBLGen Pro Projects namely – SelfServicing and Adapter.
    # In SelfServicing template group, entity objects are responsible for their own persistence (saving their own changes to DB).
    # The entity class itself contains logic to know which fields were updated and where to find the database.
    # Lazy Loading is useful cos’ it abstracts the specific DB call from the upper layers of code.
    # Adapter template group: uses an object called a DataAccessAdapter to interact with DB
    # SelfServicing: bundles persistence inside entity objects
    # Allows data to load itself automoatically as it is needed without explicit commands.

  • Comments Off
  • Filed under: .Net, Asp.net, Development, Notes, Software, Technology, Tools, VS.Net, Web, Work
  • Study Notes

    I’m learning new things these days and am just sharing some notes here. I’m still learning and these technologies are very new for me, hence my notes gonna have heaps of errors and wrong information. You are most welcome to correct them, fill some more in and share you notes with me too. Alright, so we are set to go.

    I’ll be updating this post with links so still tune.

    All the notes are subject to change as I’ll be filling in with more info later.

    MS Firefox 2007 Professional

    Arh so IE + Firefox = MS Firefox

    IE + FF = msfirefox

    Such an ugly icon. The fox now looks like a lobster with one mustache. Also it got such a long name – “Microsoft Firefox 2007 Professional Edition“. What’s up with MS and their long versions? Professional version, developer version, standard version, etc.

    The combination of Microsoft’s power and might along with Firefox’s extensive fan database will create one of the world’s largest, most innovative and diversified browsers ever. The acquisition brings together two of the industry’s strongest contenders and is the most ubiquitous incorporation of technologies for creating, managing and delivering compelling spyware and viral experiences across multiple operating systems, devices and media (Subject to Microsoft Compatibility).

    Features

    • Simplified User Experience
    • Amazing Marginal Manipulation
    • Instant Search Box
    • Favorites Center
    • RSS (Real Simple Sex)
    • Tabbed Browsing
    • Quick Tabs
    • Tab Groups
    • Page Zoom, etc..etc..

    So now what? Do we ditch recent IE7 and replace with this MSFF? Anymore IE series to come? hmm…
    Full Features | Get MS Firefox 2007 Professional Edition

    Don’t feel like testing it yet. Kinda ZzzZz..Zzz at the moment. Let me know how it goes if you tested it.

    Flickr Photos

    Downloads

    Twitter Status


    Goodie Links


    Mayvelous Friends


    In-Links
    AdBrite
    GraphicRiver
    1and1 Hosting
    oDesk

    I'm an Author for Global Voices

    Archives