Yesterday there was a discussion (again) on Vista's massive memory use. The original poster linked to an article about how Vista tries to predict the user's behavior and caches a lot of stuff. Some people argued that they rather have this memory free so that it's there whenever they actually use it, and I replied that I thought freeing memory wouldn't actually take long, and in case the OS's predictions actually were right, they could see some speed advantage.
Mike Dimmick answered a couple of my questions here[^] in great detail, and I decided to bookmark the post for future reference. It's definitely worth the read
I haven't written anything here *interesting* in a few months, mainly because I don't have anything to write, but also because we have been very busy with several projects (which is a good thing!)
Last week we finally received our new computers. I bought myself Pentium D 3.0 GHz with 160 GB of hard disk space, 2 GB of ram and dual 19" LCDs. Very cool, especially if I take into account that my previous monitor was a 17" CRT from 1997. For the two guys that work here with me, I also bought similar machines (one of them asked for a 20" wide LCD instead of two 19s.) We also got a Dell PowerEdge server for setting up a VPN and the source control repository (now a Subversion convert!). And best thing of all, I got a 13.8% discount froom the list prices (when configuring the machines on the web).
So, what projects do we have right now? We're working on the second version of the software I started last year (see "Uff, long proposal" and "Into a big project" posts below) for a company that lends money door-to-door, and then collects it weekly. The first version took over 10 months (compared to the estimated 3 months -- mainly because they were adding features not initially considered (yes, I more than doubled the initial price estimate)) and consists of over 80K lines. It's written in C# with SQL Server 2000 as database backend, and it's currently being used to manage over 7,000 customers.
The second big project is for a chain of women gyms. My client has 22 gyms in all of Mexico, and also is the master franchisee for three countries in South America (and currently has around 20 franchises over there.) The software we are developing will help them see in real time information about every gym, and keep a central database for their customers. The application is a smart client app written in C# that uses .NET remoting to communicate with a central server (which I hired in 1-800 Hosting[^] -- I recommend them!). Also there's a web application where corporate users will be able to see most of the reports (so they can see them from anywhere, and they don't need to install the client app.) A very interesting project.
Altough we have a couple of other little projects, those two are the biggest, which should take most of our time from here to June or July.
Another interesting thing that happenned is that I'm now officially a Subversion-TortoiseSVN convert! I've been using it since the beginning of this year, and I really like it. Sorry for SourceGear Vault which was a great program, but this one is easier to use, and best of all, free! [EDIT: See this thread[^] for a good discussion when I was giving SVN a try]
I'm still pending on writing that first CP article I have been promising for so long! I have a couple of ideas that would make for good, useful articles. I've just not given me the time.
Finally last week we published our business's web page. We had been very busy with our clients' projects that we had not have enough time, but now we made some space in our schedule and we finished it.
For those of you who would like to see it, it's http://www.intelectix.com[^]. Currently it's only in Spanish, but an English version is coming soon (that's what I said about our web page about a year ago ).
Feel free to post your comments on the design, and content (if you manage to understand it)
When r u going to release the page in English? I can't understand Spanish....
Unfortunately it's not a priority right now. Altough we would like to have it in English, currently we have a ton of work from paying customers, and we don't have extra time to work on our web page. It took us about 6 months to design it (and it's not so big), so probably 6 more months would be a reasonable timeframe. Altough I can't promise anything.
But I can tell you basically what we do
Intelectix is a software development company I founded back in 2004. We specialize in developing custom software solutions for small and medium business, both desktop applications and web applications.
We also sell one product, WashWorks!, which I developed about 4 years ago when my dad opened a car wash business. WashWorks! is a point-of-sale software designed specifically for car washes, with support for specific features like accumulating a customer's sales and giving a free wash if he gets 10 in 90 days for example; or rain-check in which the customer washes his car for free if it rains the day he last washed it.
And finally, we do some web design. Since web sites are more of a commodity right now, we are not precisely looking for web sites, but if one comes by, we'll take it and do our best job at it!
Thanks for stopping by at my blog , and sorry you couldn't understand our webpage
P.S. Thanks for the GMail invitation, I appreciate, but I already have an account!
I had usually endorsed VistaDB since it seemed to me a great little database for small apps. I mentioned in this[^] post some of the features I liked the most. I also sometimes even defended it in Lounge discussions.
But two days ago I was using it for a project I had to deliver three days earlier and I spent all the morning finding ways around bugs or limitations in the SQL engine. I posted three different messages in the online forum that no one from the support group (or anybody for that matter) has answered as of today, even tough they already answered newer posts.
I submitted two issues for them, and I got only one reply saying that it was planned to be supported in version 3.0 due next year.
So, what were the issues?
Trying to JOIN a table to itself. Will be supported next year. Come on, is it really that different to JOINing one table to another?
It works in Access.
I was trying to perform a INSERT INTO Table (....) (SELECT 'literal string', Field FROM Table WHERE ...) and it couldn't do it. Specifically it was blowing on the SELECT 'literal string' part, since the INSERT INTO Table (...) (SELECT ...) worked and a SELECT 0 returned a recordset with a 0 as expected. No reply on the forums, and definitely a bug for which I posted the issue and have gotten no reply.
And finally I had a query with a LEFT JOIN, that if the records were found, it returned correct results, but if no matching records were found, it returned the values from matching records for antoher condition (year) instead of NULL. I also tried this on Access with the same data and I got the expected results.
I'm using the latest version (2.0.16 released about 15 days ago.)
The first time I tried it I really liked it (see the aforementioned post) but this time I put it into use for a bigger more demanding project, it fell way short. The concept is very nice (a small self contained database) but for real uses its implementations leaves much to be desired. Also, I previously had a good experience with support, but this time that I was really desperate they just never answered.
I found one more issue the other day and I'll take the time to document it here, in case I could help someone.
I had two tables, the first with foreign keys that identify records on the second table. Basically I wanted to update all records in the first table that had a related record in the second table with one field set to one value. Sounds easy.
First I tried my newly-learnt trick (a few weeks ago in the SQL forum here in CP ):
UPDATE Table1 SET Field=False
INNERJOIN Table2 ON Table1.ForeignKey = Table2.PrimaryKey
WHERE Table2.Field = 510
It didn't work, complaining about the FROM being an unexpected token.
Ok, another try:
UPDATE Table1 SET Field=False
WHERE Table1.ForeignKey IN (SELECT PrimaryKey FROM Table2 WHERE Field = 510)
So, did it work? Of course not!
Again, I posted my inquire in the support forum and the only response I got, about a week later was from another reader that said that he had had the same problem, and that VistaDB didn't seem to like compound statements. Still no word from support
Really, I still think it's a great product. But limitations like these are making it unusable for real life projects.
If anyone has other experiences, feel free to post them here.
I didn't tell you, but I got that contract I was talking about here![^] (you don't need the link, just check below where it says "Uff... long proposal").
I started yesterday and, if my estimates are correct, I should finish by April 23rd. This week in two days I am almost finish with this week's work, so I expect by Thursday to have at least half of next week's.
It's been easy, since it's only creating the windows, toolbars, security system (user login and so on)... and I had already developed something similar earlier, so it was mainly copy/paste, tweak here, tweak there, more copy/paste, drag a control in the designer... we'll see how the following weeks turn up.
BTW, I improved my reusable multithreaded splash screen with status message, and I believe it would be a good CP article, expect it in the next few weeks.
I hope you had a great Chrsitmas and a very happy New Year, and that your resolutions become true in 2005!
Last week I came back from my 25-day vacation to Australia and New Zealand. I'll provide a quick summary.
I arrived on the 12th to Sydney where my brother picked me up. We were there for two days and then started a road trip on a rented car (which I drove, on the wrong side of the road ) and visited Bryon Bay, Nimbin, Surfer's Paradise (the Gold Coast), Hervey Bay, and Brisbane. When we were in Hervey Bay, we went to camp to Frasers Island, the largest sandy island in the world. We camped there for 2 nights, and drank about 300 between 9 people . We flew back to Sydney from Brisbane on the 22nd and met my parents there.
We spent Christmas Eve dining in my parent's hotel, with my brothers friends, and on the 26th we flew to Cairns where we went diving two days and the other to Kuranda to see some aborigenes and a tropical rain forest. On the 30th we flew to Auckland (New Zealand), we spent New Year's Eve dining in a nice restaurant and then standing on the base of the Sky City tower, where we saw the fireworks. One day we went to the Waitomo caves and somewhere close to Wellington to see a Maori museum. On Monday the 3rd, we took the plane back (a 12 hr flight followed by another 2 hr flight) and last Tuesday I arrived safely home.
Well, that's about it, in two quick paragraphs, a summary of my 25 days.
So, tomorrow I'm finally going on a long and required vacation! My brother is currently an exchange student in Sydney, and my parents and I are going to visit him.
I was going to go with my parents first to Tahiti and then to Syndey to meet my brother, but for some unknown reason (ok, they want a second honeymoon), my parents decided that I would fly directly to Sydeny while they would make a stop in Tahiti. So I asked to go a few days earlier.
The point is, I arrive on Sydeny on the 12th, and meet my parents there on the 22nd. My brother asked me to take my driving license because he and his friends have prepared a big roadtrip, and only I'm old enough to rent a car... they want to drive about 3500 kms (that's the number he told me) from Cairns to Sydney.
When we meet our parents, we'll spend about four days on each of the following cities: Sydney, Cairns and then Auckland in New Zeland. And I'm coming back to Mexico on the 3rd or January.
I'm very excited about going to the other side of the world, let's see how it turns up!
If I have time, I'll keep my single occassional reader informed with some posts here.
It's Sunday night (11:21 pm) and I've just finished. I've been all day long writing a 38 page long proposal for a software solution for a friend of my dad. He's starting a company that will sell door-to-door little credits for low-income people.
So I had several meetings with him and his partners, and I have a final meeting tomorrow, to turn in my proposal. They're also talking to other software firms, so we'll see how this comes up.
Some part of me is hoping that they choose someone else. It's such a big project that I don't how I'm going to complete it. They want it in two months. My best estimation was that I can have it in three.
But the better part of me, that which loves challenges (and the big bucks), wants it.
I'm going on vacaction this Friday, but hopefully by January when I come back, I'll have an answer. I'll keep you (my lonely ocassional reader, if I have one) informed.
I'll try to start blogging here every now and then, and see if someone, even one person, reads this!!
Well, now the real question, what do I write about?
Ah yes, yesterday I had a meeting with my first employee . He's a nice person and seems to be very intelligent. I interviewed him about two weeks ago, and yesterday I gave him his first assignment, he'll develop a little web page for one of my dad's business.
Luis Alonso Ramos wrote: I'll try to start blogging here every now and then, and see if someone, even one person, reads this!!
hmm, you'd be surprised how many people read blogs
Luis Alonso Ramos wrote: yesterday I gave him his first assignment, he'll develop a little web page for one of my dad's business.
reminds me way how I started... bt it was little asp.net app.
Luis Alonso Ramos wrote: Meanwhile I'm working in my first ASP.NET application, and what can I say, I like it! I still prefer writing desktop applications, but I'm learning a lot. I'll keep that for a later post!
yeah, ASP.NET is great
btw take a look at custom (and user) controls, this is great way how to learn a lot about standard ASP.NET webcontrols
and about ASP.NET in general.
dnh wrote: reminds me way how I started... bt it was little asp.net app
How did you start? helping someone? o giving someone an assignment? Today he came to take some pictures of the business (I have my office in my dad's business, but mine is a completely independent business).
dnh wrote: take a look at custom (and user) controls
I've read about them before. I haven't had the need for them yet, but when I do, I know I'll learn a lot.
This new employee of mine was telling me he didn't know much about programming, only a little ASP (but he's good at graphics, something I'm not). I told me that he would have learn a lot by doing different projects, and that I would be happy to help him learn. He seems to like the idea, so probably he'll later (when he finishes school) become someone very valuable to my business.
dnh wrote: no. My first work was small web app I was in similar position as your employee, not in your position 
How did you get it?
I got my first job about four years ago, a friend of my dad required a software to be developed and my dad recommended me. I charged a lot of money, but they were very happy with the result (to the point he is still my client, and currently we're studying and designing a project, that will be close to my limits as a single developer.)
When I finished school last may, I came back to Chihuahua (my city) and started my own little business. I haven't spent a single peso (Mexican currency) in advertising, and still I have more work than I can do. I've had no time to develop my own web page (if this guy comes out as good as it seems, he'll do it for me!)
Now I finally got a little project to give it a try. My findings:
* Simple to use. I used the ADO.NET provider, and it's basically the same as using the OleDb* or SqlDb* clasess. True, I didn't use the most advanced features (mostly DataReaders) but it works good.
* The documentation, for lack of a better word, sucks. The class library documentation, mostly, is something like "GetDate method: gets a date." I was having trouble with an exception when I was trying to connect to the database. You don't pass the filename of the database, but a connection string like "Database=filename.vdb".
* Support. I used the support forums twice. Once I found the answer in a previous thread, and the other time I got a very quick reply, although I had solved the problem myself 5 minutes earlier.
* Different SQL. I had a little trouble with a SELECT statement that works differently that what had worked for me in Access and MSDN. If using wildcards, you must use 'Like' instead of "=" as in "SELECT * FROM Table WHERE FirstName Like = '%blahblah%';"
* Easy to deply. Copy two DLLs and that's it.
Well, that's about it. Overall, I'm very satisfied with it, and it does what it is supposed to very well.
My only requesst is that it would work (or they would tell us how to do it) with OleDb* classes, so migration to MSDE would be as simple as changing the connection string.