197 reputation
19
bio website
location
age
visits member for 3 years, 5 months
seen Sep 4 at 7:08

Mar
25
awarded  Nice Question
Feb
13
awarded  Notable Question
Dec
27
awarded  Popular Question
Oct
12
awarded  Critic
Aug
30
awarded  Teacher
Aug
30
answered How mature is FreeBASIC?
Jul
29
awarded  Scholar
Jul
29
accepted Isn't SQLite a bit underestimated?
Jul
28
comment Isn't SQLite a bit underestimated?
@Jeff O: Right. I would only choose SQLite if the number of users is relatively low (< 10-15) and also the total amount of data isn't high. In our experience the total database size is often 300-400MB and almost never > 1GB.
Jul
28
awarded  Commentator
Jul
28
comment Isn't SQLite a bit underestimated?
I respect you opinion. I'm just a practical man. When I choose a tool I choose it because I think it's the most realistic/practical decision. I'm not fascinated with SQLite, but do admire the way they managed to put so much in such a small, efficient and fast package. Like I mentioned in my question: if MS-SQL is a better tool for a particular job, then I would simply choose that. But, like I explained, in many occasions I truly believe that SQLite just suited fine.
Jul
28
revised Isn't SQLite a bit underestimated?
added 484 characters in body
Jul
28
comment Isn't SQLite a bit underestimated?
@Jeff O: I guess you misunderstood my intentions. I'm not choosing SQLite because it's free, cheap and/or easy to install. I would choose it only because it's small, fast and resource friendly. So it's mainly for practical/technical reasons. Many of our customers don't spend much on hardware, so I often encounter a sole server with everything on it (Exchange, SQL, etc) and because of that are almost "out of breath". If I could deliver a product that hasn't high system requirements, then my customer would be happy. SQLite doesn't add any weight, MSSQL does.
Jul
28
comment Isn't SQLite a bit underestimated?
I looked at CE, but somehow it seems that SQLite is better/faster/easier. Don't know for sure, I didn't used/tested CE enough to be sure.
Jul
28
revised Is experience in business analysis useful when moving into a programming career?
added 83 characters in body
Jul
28
answered Is experience in business analysis useful when moving into a programming career?
Jul
28
awarded  Supporter
Jul
28
revised Isn't SQLite a bit underestimated?
added 3 characters in body
Jul
28
comment Isn't SQLite a bit underestimated?
@sarat: Afaik SQLite does use memory caches intensively.
Jul
28
comment Isn't SQLite a bit underestimated?
You're right. I don't think you meant it that way, but I can assure you that I'm not an amateur. I definitely will user "real" DBMS systems if the situation would ask for it. Our products are licensed for a number of users. I would only develop using SQLite if I know that the number of users are relatively small (< 10-15). If the customer would exceed a limit, which in our customer base will not happen soon, we can always relatively quickly/simple convert them to an other database. That's not rocket science ;). Based on your remarks, I rephrased the question to make it more clear.